 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.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.0015.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.0014.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. For example, 17.76 would be a legitimate entry.
Answer Key: 3.504.50
Question 4 of 20 1.0 Points
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.
The distribution of the data given is:  MATH302_Midterm.xls 30 KB  
 A. Normally distributed 
 
 B. Positively Skewed 
 
 C. Negatively Skewed 
 
 D. Binomially distributed 
Answer Key: B
Question 5 of 20 1.0 Points

An urn contains 12 balls identical in every respect except their color. There are 3 red balls, 7 green balls, and 2 blue balls. You draw two balls from the urn, but replace the first ball before drawing the second. Find the probability that the first ball drawn is red and the second ball drawn is green. Place your answer, rounded to 4 decimal places, in the blank. For example, 0.4567 would be a legitimate entry. .1458
Answer Key: 0.13500.1550
Question 6 of 20 1.0 Points

Ann is applying for a bank loan to open a pizza franchise. She must first complete a written application and then, if the written application is approved, be interviewed by bank officers. If an applicant’s written application is not approved the applicant is not granted an interview with the bank officers. Past records for this bank show that the probability of an applicant having his or her written application approved is 0.63. Records also indicate that the interviewing committee of bank officers approves 85% of the individuals they interview. Find the probability that Ann’s loan request is approved. Place your answer, rounded to 2 decimal places, in the blank. For example, 0.76 would be a legitimate entry. .54
Answer Key: 0.450.65
Question 7 of 20 1.0...