Chat with us, powered by LiveChat What is the primary diagnosis ? 2- What potential risk factors were there? 3- Make a statistical description of the data ( primerly diagnosis, risk factors - The EssayHub

What is the primary diagnosis ? 2- 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 Includeing  tables and graphs with explanation

diabet_typ2_1000case

<td

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