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 q
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
diabet_typ2_1000case
AGE | AMONTH | AWEEKEND | DIED | DISCWT | 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 | Diabetes_type2_no_complications | Diabetes_type2_with_complications | Family_history | GESTATIONAL_DIABETES | ANTEPARTUM_DIABETES | POSTPARTUM_DIABETES | dyslipidemia | Hyperinsulinemia | Hyperlipidemia_NOS | Non_alcoholic_steatohepatitis | Metabolic_Syndrome | Obesity | Smoking | Alcohol_related_disorders | Hypertension | Polycystic_ovary_syndrome | Pure_hypercholesterolemia | Pure_hyperglyceridemia | Asthma | Vitamin_d_deficiency | PERSONAL_HISTORY_OF_ALCOHOLISM | Substance_related_disorders | Age_Group | PRE_1 | PRE_2 | filter_$ |
56 | 2 | 0 | 0 | 4.4814726 | 1 | 296 | 296 | 24 | 2768 | 2639 | 4019 | 43889 | 78791 | 7993 | 2449 | 6826 | 28529 | 78039 | 25000 | 2761 | 30391 | 5711 | 2910 | 55 | 52 | 98 | 113 | 155 | 259 | 48 | 197 | 59 | 83 | 49 | 55 | 660 | 663 | 660 | E9370 | E9394 | E8497 | E9361 | 0 | 2617 | 2617 | 2621 | 2617 | 1 | 4 | 0 | 15 | 10 | 10 | 21 | 4 | 0 | 1 | 3 | 1 | 3893 | 54 | 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! | 11 | 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 | 177092 | 2007 | 4 | 425 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 9117 | 9850 | 7826 | 7441 | 3359 | 3124 | 9455 | 4989 | 8746 | 3183 | 8658 | 8237 | 7661 | 5229 | 7454 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.00 | 0.03917 | 0.03922 | 0 | ||||||||||||||
72 | 12 | 0 | 0 | 4.4814726 | 1 | 127 | 127 | 24 | 4280 | 2800 | 58381 | 4240 | 4552 | 4660 | 2113 | 25042 | 2768 | 5180 | 4168 | 3970 | 4254 | 56210 | 42731 | 108 | 59 | 156 | 96 | 120 | 125 | 47 | 50 | 55 | 130 | 103 | 96 | 97 | 146 | 106 | 0 | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | 1 | 4 | 0 | 7 | 5 | 5 | 19 | 0 | 0 | 1 | 1 | 1 | 4542 | 95 | 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! | 6 | 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! | 3 | 62149 | 2007 | 4 | 194 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 7225 | 9698 | 6562 | 7588 | 7204 | 7028 | 9685 | 9262 | 8859 | 6239 | 6684 | 6628 | 6335 | 5294 | 6010 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.00 | 0.20087 | 0.20091 | 0 | ||||||||||||||||||
62 | 6 | 0 | 0 | 4.4814726 | 2 | 182 | 182 | 24 | 00869 | 2521 | 2449 | 53081 | 2113 | V5867 | 58889 | 2768 | 33829 | 27900 | V1259 | 25000 | 27541 | 2738 | 27651 | 135 | 51 | 48 | 138 | 47 | 257 | 161 | 55 | 95 | 57 | 117 | 49 | 58 | 58 | 55 | 0 | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | 1 | 4 | 0 | 7 | 6 | 6 | 16 | 0 | 0 | 1 | 6 | 1 | 4542 | 95 | 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! | 6 | 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 | 58435 | 2007 | 4 | 249 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11172 | 9920 | 9951 | 6820 | 9941 | 354 | 6128 | 9066 | 8088 | 8558 | 783 | 8434 | 8075 | 7842 | 7651 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.00 | 0.15556 | 0.15572 | 0 | ||||||||||||||||||
86 | 9 | 0 | 0 | 4.4814726 | 3 | 172 | 172 | 24 | 1536 | 496 | 53550 | 3572 | 2859 | 25040 | V5867 | 42731 | 43330 | 2767 | 4019 | 25060 | 27651 | 58381 | 4280 | 14 | 127 | 140 | 95 | 59 | 50 | 257 | 106 | 110 | 55 | 98 | 50 | 55 | 156 | 108 | 0 | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | 1 | 4 | 0 | 7 | 6 | 6 | 25 | 0 | 0 | 3 | 1 | ERROR:#NULL! | 4516 | 9904 | 4525 | 70 | 222 | 76 | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | 2 | 1 | 3 | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | ERROR:#NULL! | 2 | 59134 | 2007 | ERROR:#NULL! | 240 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10225 | 7303 | 6850 | 8578 | 9343 | 9529 |