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 …show more content…
Place your answer, rounded to 4 decimal places, in the blank. .68
Answer Key: 0.6800 | Question 10 of 20 | 1.0 Points | |
In February 2002 the Argentine peso lost 70% of its value compared to the United States dollar. This devaluation drastically raised the price of imported products. According to a survey conducted by AC Nielsen in April 2002, 68% of the consumers in Argentina were buying fewer products than before the devaluation, 24% were buying the same number of products, and 8% were buying more products. Furthermore, in a trend toward purchasing less-expensive brands, 88% indicated that they had changed the brands they purchased. Suppose the following complete set of results were reported. Use the following data to answer questions 9 through 12. | Number of Products Purchased | | Brands Purchased | Fewer | Same | More | Total | Same | 10 | 14 | 24 | 48 | Changed | 262 | 82 | 8 | 352 | Total | 272 | 96 | 32 | 400 |
What is the probability that a consumer selected at random purchased the same number or more products than before? Place your answer, rounded to 4 decimal places, in the blank. .32
Answer Key: 0.3200 | Question 11 of 20 | 1.0 Points | |
In February 2002 the Argentine peso lost 70% of its value compared to the United States dollar. This devaluation drastically raised the price of imported products. According to a survey conducted by AC Nielsen in April