The 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.15 Do not use a percent sign. For example, 17.76 would be a legitimate entry.
Answer Key: 13.00|15.00 | Question 2 of 20 | 1.0 Points | | MATH302_Midterm.xls | 30 KB |
The 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. 13.5 Do not use a percent sign. For example, 17.76 would be a legitimate entry.
Answer Key: 13.00|14.00 | Question 3 of 20 | 1.0 Points | | MATH302_Midterm.xls | 30 KB |
The 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.10 Do not use a percent sign.