Part 1 of 1 -20.0 PointsQuestion 1 of 201.0 PointsMATH302_Midterm.xls30 KBThe worksheet “Insurance” in the Excel workbook MATH302_Midterm.xls, which is attached, contains data on the percentage of people without health insurance coverage. These data are based on samples taken in 2004 for the fifty states and the District of Columbia. Use these data to answer questions 1 through 4.On average, what percentage of the people in the fifty states and the District of Columbia does not have health insurance? Place your answer, rounded to 2 decimal places, in the blank. 14.15Do not use a percent sign. For example, 17.76 would be a legitimate entry.Answer Key: 13.00|15.00

Question 2 of 201.0 PointsMATH302_Midterm.xls30 KBThe worksheet “Insurance” in the Excel workbook MATH302_Midterm.xls, which is attached, contains data on the percentage of people without health insurance coverage. These data are based on samples taken in 2004 for the fifty states and the District of Columbia. Use these data to answer questions 1 through 4. Based on the data provided, what is the median percentage of people who do not have health insurance in the fifty states and the District of Columbia? Place your answer, rounded to 2 decimal places, in the blank.

Question 3 of 201.0 PointsMATH302_Midterm.xls30 KBThe worksheet “Insurance” in the Excel workbook MATH302_Midterm.xls, which is attached, contains data on the percentage of people without health insurance coverage. These data are based on samples taken in 2004 for the fifty states and the District of Columbia. Use these data to answer questions 1 through 4. Find the standard deviation of the percentage of people in the fifty states and the District of Columbia who do not have health insurance. Place your answer, rounded to 2 decimal places, in the blank. 4.13Do not use a percent sign. For example, 17.76 would be a legitimate entry.

Question 4 of 201.0 PointsThe worksheet “Insurance” in the Excel workbook MATH302_Midterm.xls, which is attached, contains data on the percentage of people without health insurance coverage. These data are based on samples taken in 2004 for the fifty states and the District of Columbia. Use these data to

answer questions 1 through 4. The distribution of the data given is:MATH302_Midterm.xls30 KB

B