What is the primarly diagnosis ? What potential risk factors were there? 3- Make a statistical description of the data ( primerly diagnosis, risk factors,
May 5, 2024
Â
Attached two files , one for the data you will work on in excel file and file discription for the data in PDF
As a data scientist please study the data and answer the following questionsÂ
1- what is the primerly diagnosis ?
2- What potential risk factors were there?
3- Make a statistical description of the data ( primerly diagnosis, risk factors, gender, age ,…etc)
4- is there a statistal relastionship between the primerly diagnosis and its risk factors?
please show your work in excel file and pdf file Including tables and graphs with explanation
datasetfordataproject.xlsx
NIS_2007_INTRODUCTION.pdf
diabetes type2_100
AGE
AMONTH
AWEEKEND
DIED
DQTR
DRG
DRG24
DRGVER
DX1
DX2
DX3
DX4
DX5
DX6
DX7
DX8
DX9
DX10
DX11
DX12
DX13
DX14
DX15
DXCCS1
DXCCS2
DXCCS3
DXCCS4
DXCCS5
DXCCS6
DXCCS7
DXCCS8
DXCCS9
DXCCS10
DXCCS11
DXCCS12
DXCCS13
DXCCS14
DXCCS15
ECODE1
ECODE2
ECODE3
ECODE4
ELECTIVE
E_CCS1
E_CCS2
E_CCS3
E_CCS4
FEMALE
HCUP_ED
HOSPBRTH
LOS
MDC
MDC24
NDX
NECODE
NEOMAT
NPR
PAY1
PL_NCHS2006
PR1
PR2
PR3
PR4
PR5
PR6
PR7
PR8
PR9
PR10
PR11
PR12
PR13
PR14
PR15
PRCCS1
PRCCS2
PRCCS3
PRCCS4
PRCCS5
PRCCS6
PRCCS7
PRCCS8
PRCCS9
PRCCS10
PRCCS11
PRCCS12
PRCCS13
PRCCS14
PRCCS15
PRDAY1
PRDAY2
PRDAY3
PRDAY4
PRDAY5
PRDAY6
PRDAY7
PRDAY8
PRDAY9
PRDAY10
PRDAY11
PRDAY12
PRDAY13
PRDAY14
PRDAY15
RACE
TOTCHG
YEAR
ZIPINC_Q
APRDRG
CM_AIDS
CM_ARTH
CM_CHF
CM_COAG
CM_DM
CM_DMCX
CM_DRUG
CM_HTN_C
CM_LIVER
CM_LYMPH
CM_LYTES
CM_METS
CM_NEURO
CM_OBESE
CM_PARA
CM_PSYCH
CM_TUMOR
CM_ULCER
CM_VALVE
dx1_code
dx2_code
dx3_code
dx4_code
dx5_code
dx6_code
dx7_code
dx8_code
dx9_code
dx10_code
dx11_code
dx12_code
dx13_code
dx14_code
dx15_code
PRE_1
PRE_2
50
1
0
0
1
547
547
24
41071
58181
4589
6823
4149
41401
25050
5859
36201
42731
40390
9993
5849
25040
4280
100
156
117
197
101
101
50
158
87
106
99
238
157
50
108
0
ERROR:
Trust your assignments to an essay writing service with the fastest delivery time and fully original content.