1. Notice that not all states have complete data. For example, Alaska only has data listed under “all ages” and nothing for females

Answer the following questions:

1. What was the average death rate (number of deaths per 100,000) for males in 2012?
2. What was the average death rate (number of deaths per 100,000) for females in 2012?
3. How did you handle the missing data ?
4. How would you compare the rate for males against the rate for females?
5. Run descriptive statistics on the four Age columns (Age 0-20, Age 21-34, Age 35-54, Age 55+). Which has the highest death rate? Does that make sense to you?

1 State 2 Alabama 3 Alaska 4 Arizona 5 Arkansas 6 California 7 Colorado 8 9 Delaware 10 Florida 11 Georgia 12 Hawaii 13 Idaho Connecticut 14 Illinois 15 Indiana 16 lowa 17 Kansas 18 Kentucky 19 Louisiana 20 Maine 21 Maryland 22 Massachusetts 23 Michigan 24 Minnesota 25 Mississippi 26 Missouri 27 Montana 28 Nebraska 29 Nevada 30 New Hampshire 31 New Jersey 32 New Mexico 33 New York 34 North Carolina 35 North Dakota 36 Ohio 37 Oklahoma 38 Oregon 39 Pennsylvania 40 Rhode Island 41 South Carolina 42 South Dakota 43 Tennessee 44 Texas 45 Utah 46 Vermont 47 Virginia 48 Washington 49 West Virginia 50 Wisconsin 51 Wyoming 52 53 A B Age 0-20 8.6 2.4 3.3 3.5 3.9 4.5 2.5 5 4.4 7.5 6.7 6.9 6.6 3.3 1.8 3.8 2.9 8.6 5.5 10.6 7.7 3.5 2.1 6 1.7 5.1 11 3.6 6 2.6 4.5 6.8 9.5 6.1 5.2 2.5 3.9 2.1 5.9 4.8 C Age 21-34 20.8 12 20.3 6.9 8.8 7.5 13 10 12.1 12 8.8 12 11.7 13.9 19.7 15.6. 18 9.3 4.7 10.9 7.8 24.6 15.3 29.6 13.6 6.2 6.2 14.3 4.1 12.5 25.2 9.6 22.7 7.9 11.1 19.8 17.9 16.4 14.5 6.7 19.2 8.9 5.3 22.6 10.9 29.5 D Age 35-54 12.6 7.3 13.8 4 4.8 4 6.7 8.2 8.8 3.6 7.2 9.6 10.7 13.4 10.3 7.3 4.2 2.2 4.9 4.3 16.7 11.6 17 8.1 4.6 2.8 13.7 2.9 8.7 27 7.6 15.7 4.3 6.4 12.7 12.1 12.3 8.9 6.8 6.7 4.2 13.7 7.4 14.9 E Age 55+ 15.5 6.9 16.2 4.5 7.3 5.2 7.2 12.1 10.9 5.6 9.9 10.3 13.1 13.7 10.5 9.1 6.1 3.9 7.5 6.5 17.6 10.4 12.5 9.1 8.4 6.8 4.7 11 4.4 9.9 18.6 8 15.9 7.3 7.3 11.8 10.1 15 9.5 6.4 9.3 4.3 13.7 8 20.7 F All Ages 13.7 5.4 7.4 13.8 4.2 5.8 4.1 6.9 6.4 8.5 4 8.6 4.7 8.1 8.7 11 12.9 10.4 9.4 5.3 2.9 6.2 5.1 16 10.2 16.4 9.2 5.4 5 3.6 11.1 3.1 8.6 20.2 6.9 14.3 5.1 6.8 4.5 12 12 11.7 9.1 5.5 8.4 6.8 3.9 13.1 7.4 17.5 G Male 17.6 5.5 10.2 17.3 5.6 7.4 5.4 10 8.4 11.7 5.7 10.4 6.3 10.9 11.3 15.1 15.7 13.9 13.2 7.1 4.1 8.3 6.2 22.3 14.2 21.9 12.8 6.5 7.3 5 15.1 4.2 11.5 29.3 9.1 19.2 5.9 9.2 6.3 17 15.4 16.8 12.2 5.9 10.2 9.3 5.2 19.1 9.6 21.9 - 1 GNESE** ***>======*@^@~38~2328*# #*3--*@*~GA Female