MATH125: Unit 5 Individual Project Visual Representation and Analysis of Data State Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Georgia Hawaii Idaho Illinois3 Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachuse tts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvani a Rhode Island South Carolina South Total murder s1 Total firearm s Handgu ns Rifle s Shotgu ns Knives or cutting instrumen ts Other weapon s 3 9 6 50 5 1 3 1 Firearm s (type unknow n) 8 34 48 259 26 38 7 39 6 49 22 261 22 18 8 21 5 59 17 208 31 10 2 9 Hand s, fists, feet, etc.2 2 9 4 101 21 6 3 1 29 339 153 1,790 147 128 41 108 16 222 110 1,220 73 94 28 77 5 165 52 866 39 54 18 37 0 14 4 45 3 1 0 0 522 7 32 452 284 44 110 150 485 25 398 183 370 1 17 377 183 19 73 100 402 12 272 122 326 0 15 364 115 7 31 77 372 3 262 52 16 1 1 1 9 0 3 6 10 1 2 0 16 0 0 5 12 2 5 5 8 1 5 1 12 0 1 7 47 10 34 12 12 7 3 69 61 2 4 29 36 10 11 13 28 4 75 30 83 1 8 29 43 10 16 24 29 7 34 22 8 3 3 17 22 5 10 13 26 2 17 9 613 70 187 364 18 65 129 16 450 43 138 276 7 42 75 6 267 36 121 158 2 35 46 1 29 3 6 13 3 2 2 2 15 3 4 9 1 1 1 1 139 1 7 96 1 4 26 2 43 12 26 28 4 7 20 4 89 12 14 42 5 9 25 6 31 3 9 18 2 7 9 0 379 121 774 489 269 60 445 335 238 45 394 235 1 2 5 26 5 2 16 19 25 11 30 55 51 21 160 60 41 32 143 57 18 8 26 37 12 6 3 0 0 3 4 0 2 488 204 77 636 344 131 40 470 187 99 13 379 8 8 1 8 13 9 2 19 136 15 24 64 44 26 22 73 80 21 10 66 20 26 5 27 14 5 1 0 0 4 5 4 0 319 223 126 10 12 75 38 40 18 15 5 3 1 0 1 4 3 3 Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Virgin Islands 373 1,089 51 8 303 161 74 244 699 26 4 208 79 43 172 497 15 2 110 58 23 7 37 4 0 10 1 10 13 48 1 0 15 3 3 52 117 6 2 73 17 7 51 175 5 2 33 29 11 62 134 9 2 41 36 13 16 81 11 0 21 17 7 135 15 38 80 11 31 60 7 27 7 0 0 3 0 0 10 4 4 21 0 5 13 1 2 21 3 0 1 Total number of murders for which supplemental homicide data were received. Pushed is included in hands, fists, feet, etc. 3 Limited supplemental homicide data were received. 2 (FBI, 2011) The table above for murders by weapon types is from the FBI's Criminal Justice Services Division and represents the reported murders in each state for the year 2011. (Please see http://www.fbi.gov/aboutus/cjis/ucr/crime-in-the-u.s/2011/crime-in-the-u.s.-2011/tables/table-20 for the referenced table.) Complete the following and insert the required responses and descriptions in a Word document. Submit your Word documents in the Unit 5 IP Submissions area. 1. From the data in the table above, using the top 7 states for number of murders, construct a table showing the number of murders by each category of firearms. 2. From the data in the table above, using the top 7 states for number of murders, construct a 3. 4. 5. 6. pie chart representing the number of murders in each state committed with handguns; use percentages to make sure that the pie chart is correctly proportioned. From the data in the table above, using the top 7 states for number of murders, construct a bar chart representing the number of murders in each state committed with handguns; use percentages to make sure that the bar chart is correctly proportioned. From the data in the table above using the top 7 states for number of murders, construct an area chart representing the number of murders in each state committed with handguns; use actual numerical values and make sure the area chart is correctly proportioned. Which of these three chart types do you think gives the most useful visual information about the data represented? Is there another chart type that you think would better represent these data? Why or why not? Reference Federal Bureau of Investigation. (2011). Table 20: Murder. Retrieved from http://www.fbi.gov/aboutus/cjis/ucr/crime-in-the-u.s/2011/crime-in-the-u.s.-2011/tables/table-20