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
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:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
0
0
0
20
5
5
21
0
0
10
3
1
3613
3615
3964
9672
9744
3761
8853
3961
8856
3722
44
44
50
216
63
49
47
50
47
47
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
5
5
5
5
6
5
0
5
0
0
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
1
552337
2007
4
165
0
0
0
0
0
1
0
1
0
0
0
0
0
1
0
0
0
0
0
7341
6658
7398
5244
7519
7425
9404
6056
7821
6742
6764
945
5300
7993
5999
0.17624
0.17631
61
3
0
0
1
202
202
24
5715
7895
4553
56210
28529
V641
25000
56723
56400
30503
4564
2113
2867
1105
07054
151
151
120
146
59
259
49
148
155
660
121
47
62
4
6
0
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
0
4
0
7
7
7
17
0
0
3
1
1
9907
4542
5491
222
95
88
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
1
3
2
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
3
43819
2007
2
283
0
0
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6233
3491
7423
6626
9346
255
9424
6215
6068
8136
6367
8675
7935
8784
8758
0.17239
0.17237
73
3
0
0
1
579
579
24
99859
6822
25000
V454
56210
78909
5690
5990
2768
2760
2859
0416
2767
2113
99832
238
197
49
211
146
251
147
159
55
55
59
3
55
47
238
E9412
E8497
E8781
0
2617
2621
2616
ERROR:#NULL!
1
0
0
18
18
18
22
3
0
7
6
1
7809
4542
4836
9904
3893
9929
8309
161
95
95
222
54
231
160
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
7
4
4
8
16
4
7
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
1
244267
2007
4
711
0
0
0
0
1
0
0
1
0
0
1
0
0
0
0
0
0
0
0
620
5374
9917
527
6528
3278
6279
5975
8859
8604
8335
9488
8058
8241
902
0.10358
0.10367
53
1
0
0
1
127
127
24
4280
5849
71650
2724
7905
40390
7806
72888
71946
41400
412
V4581
2761
25000
5859
108
157
204
53
151
99
246
211
204
101
101
101
55
49
158
E8859
E8499
0
2603
2621
ERROR:#NULL!
ERROR:#NULL!
1
4
0
4
5
5
18
2
0
0
2
1
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
1
55614
2007
2
194
0
0
0
0
1
0
0
1
0
0
1
0
0
0
0
0
0
0
0
7225
6635
4909
9642
3279
7484
3412
4275
4369
6830
6712
458
8068
8009
5002
0.20179
0.20236
43
3
0
0
1
127
127
24
4280
4254
V5866
V5867
2768
40390
27801
2761
2724
41401
V1581
25000
4660
2967
5859
108
97
257
257
55
99
58
55
53
101
259
49
125
657
158
0
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
0
0
0
1
5
5
15
0
0
0
2
1
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
ERROR:#NULL!
The post What is the primarly diagnosis ? What potential risk factors were there? 3- Make a statistical description of the data ( primerly diagnosis, risk factors, first appeared on Writeden.