B C D G M Factors that Affect High School Completion Rates for 2013-2014 State Completion Rate Alabama 86 PART 1 - Question 1 PART 1 - Question 2 Alaska 71 Completion Rate Data Analysis This statistic tells me that the average completion rate is at _. The middle 5 Arizona 76 Mean completion rate is at 84.5% 6 Arkansas 87 Median California 81 Mode Colorado 77 Maximum 9 Connecticut 87 Minimum Delaware 87 Range 11 76 Standard Deviation 12 Georgia 73 13 Hawaii 82 14 Idaho 77 PART 1 - Question 3 15 Illinois 86 Group / Class Frequency PART 1 - Question 4 - insert graph below PART 1 - Question 5 16 Indiana 88 60-64 0 17 lowa 91 65-69 1 18 Kansas 86 70-74 4 19 Kentucky 88 75-79 10 20 Louisiana 75 80-84 10 21 87 85-89 23 22 Maryland 86 90-94 2 23 Massachusetts 86 24 Michigan 79 25 Minnesota 81 26 Mississippi 78 27 Missouri 87 28 Montana 85 29 Nebraska 90 30 Nevada 70 31 New Hampshire 88 32 New Jers 89 33 New Mexico 69 34 New York 78 35 North Carolina 84 36 North Dakota 87 37 Ohio 82 38 Oklahoma 83 39 Oregon 72 40 Pennsylvania 85 41 Rhode Island 81 42 South Carolina 80 43 South Dakota 83 44 Tennessee 87 45 Texas 88 46 Utah 84 47 8 8 48 Virginia 85 49 78 50 West Virginia 85 51 Wisconsin 89 52 Wyoming 79Part 1: Completion Rates 1 Locate the completion rate data for each state on the \"Completion Rate by State\" tab. Calculate the mean, median, mode, maximum, minimum, range, and standard deviation for the completion rates. Use Excel formulas to calculate the values. Using a minimum of five sentences, explain what the statistics calculated in the previous question tell you about the high school completion rates in 2013-14. Type your answer in the box provided on the Excel file. Create a grouped frequency distribution for the completion rate data. The first class should start at 60 and use a class width of 5. Fill in the grouped frequency distribution in the excel file. Create a histogram based on the grouped frequency distribution you created. Insert the graph on the excel file in the provided space. Be sure to use the bar chart and change the gap width. Using a minimum of three sentences, explain what the histogram tells you about high school completion rates in 2013-14