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

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

Order a plagiarism free paper now

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.

Order a Similar Paper
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!