What is the primarly diagnosis ? What potential risk factors were there? 3- Make a statistical description of the data ( primerly diagnosis, risk factors,
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! |