Your task is to complete this report using Word and a programming language at your choice (Python or JAVA or R) and to submit the complete word document on Canvas. Submit using Canvas. Make sure you double check that the file has been added to Canvas.
To gain full points on each of the questions, you will need to include the results, explanations and code, and following the instructions.
Given the county ranking data set (2017CHR_CSV_Analytic_Data.csv) and its description (2017CountyHealthRankingsData.xls),
Task 1. Normalize any three the features to range (0,1). Please include results and code. (refer the code in my slides) (10 points)
Task 2. Create four bins based on the diabetes value and label the bins. Please include results, explanation and code. (refer the code in my slides) (20 points)
Cut Calibri 11 A = B Share Comm a Wrap Text Paste General Le Copy Format Painter AutoSum B I U a A V 28 O Merge & Center $ % % 960 Fill 00 -0 Conditional Format as Cell Formatting Table Styles Insert Delete Format Clipboard V Font Clear Sort & Find & Filter Select Sensitivity Analyze Data Alignment Number Styles KR1 Cells fix Percent of population below 18 years of age denominator Editing Analysis Sensitivity A B C D 1 5-Digit FIP statecode countycod state 2 1000 1 O AL 3 1001 1 1 AL 4 1003 1 3 AL 5 1005 1 5 AL 6 1007 7 AL 7 1009 1 9 AL 3 1011 1 11 AL 3 1013 1 13 AL 0 1015 1 15 AL 1 1017 1 17 AL 2 1019 1 19 AL 3 1021 1 21 AL 4 1023 1 23 AL 4 5 1025 1 25 AL 27 AL E F G H J K L M N county Q County tha Premature Premature Premature death Premature death Lower Premature Poor or fai Poor or fair healt Poor or fai Poor or fai Poor or fai Poor physi Poor physi Poor physi Poor physi Poc R S T Alabama 9,573 75,262 13,597,347 9,474 9,673 0.212 0.2 0.225 4.5 Autauga County 4.2 9,158 830 157,247 8,251 10,065 0.179 0.173 0.184 4.2 Baldwin County 4 7,394 2,573 543,456 6,947 7,840 0.164 0.159 0.169 3.7 Barbour County 3.6 8,573 413 75,937 7,292 9,854 0.25 0.244 0.256 4.8 4.6 Bibb County 11,766 407 63,769 10,034 13,498 0.195 0.189 0.201 4.4 4.2 Blount County 9,333 906 162,148 8,430 10,236 0.189 0.183 0.196 4.5 4.3 Bullock County 10,858 180 29,866 8,576 13,139 0.283 0.274 0.291 5 4.7 Butler County 12,427 401 55,776 10,593 14,262 0.266 0.259 0.274 5.2 5 Calhoun County 10,717 2,133 326,941 10,042 11,392 0.22 0.215 0.225 4.9 4.7 Chambers County 11,410 700 94,471 10,132 12,689 0.245 0.239 0.251 4.8 4.6 Cherokee County 12,534 544 72,392 10,843 14,224 0.193 0.186 0.2 4.5 4.3 Chilton County 10,678 770 123,763 9,590 11,767 0.209 0.202 0.215 4.7 4.5 Choctaw County 12,937 266 36,982 10,543 15,332 0.25 0.242 0.256 5 4.8 Clarke County 9,469 395 69,639 8,057 10,881 0.229 0.223 0.235 4.9 4.7 Clay County 9,390 225 37,065 7,366 11,414 0.211 0.204 0.218 4.6 4.4 Cleburne County 11,803 319 41,683 9,861 13,746 0.172 0.166 0.179 4.1 3.8 Coffee County 7,630 702 143,005 6,773 8,487 0.189 0.184 0.195 4.3 4.1 Colbert County 10,253 1,017 150,563 9,273 11,234 0.199 4.3 0.193 0.205 4.5 12,828 277 Conecuh County 35,359 10,366 5.1 15,289 0.269 0.277 0.284 5.3 4.6 204 30,373 0.226 0.232 8,421 6,380 Coosa County 0.239 4.7 10,461 0.212 0.219 4.4 0.206 8,764 4.6 700 Covington County 11,071 103,767 9,918 0.203 0.197 0.208 4.1 8,822 4.2 262 Crenshaw County 12,781 10,801 38,967 4.3 0.208 9,148 0.201 0.215 4.5 10,726 225,510 9,937 Cullman County 1,365 4.5 0.209 7,249 0.22 0.215 4.6 8,922 732 *8,086 140,623 Dale County 0.273 5.3 0.28 0.287 5.5 11,682 14,174 878 12,928 118,644 Dallas County 4.8 5 8,834 0.223 0.216 0.229 10,449 199,936 1,147 DeKalb County 9,642 Sheet1 + Count: 2 8:49 PM w ? 70F 9/20/202 99+ 1027 1 1029 1 29 AL 6 7 8 9 1031 1 31 AL 1033 1 0 1035 1 33 AL 35 AL 37 AL 1037 1 1039 1 39 AL 1041 1 41 AL 1 2 3 4 5 5 7 1043 1 43 AL 1045 1 45 AL 1047 1 47 AL 1049 1 49 AL 2017CHR_CSV_Analytic_Data eady PC P O Type here to search OBI ( hp
