Assignment:
1. For this problem, you will use the data included in the workbook “Homework 4_Data.xlsx” and the worksheet “Health”. You are an analyst for the local health department and have been asked to conduct an analysis to determine the significant factors that affect the death rate per 1000 To do so, complete the following:
(1) Perform a multiple regression analysis using “death rate per 1000 residents” as the dependent variable. Independent variables include: “doctor availability per 100,000 residents”, “hospital availability per 100,000 residents”, “annual per capita income in thousands of dollars”, and “population density people per square mile”.
(2) At a confidence level of 90%, what are the significant factors that affect “death rate per 1000 residents”?
(3) After excluding variables that are not significant (if there are any), re-run the multiple regression analysis at a confidence level of 90%. What is the resulting model that describes “death rate per 1000 residents” as a function of the significant variables?
(4) Using your result from 1c, predict the “death rate per 1000 residents based on the following:
- doctor availability per 100,000 residents = 75
- hospital availability per 100,000 residents = 875
- annual per capita income in thousands of dollars = 15
- population density people per square mile = 183
2. For this problem, you will use the data included in the workbook “Homework 4_Data.xlsx” and the worksheet “Piston”. You are a quality engineer for an automotive manufacturer who buys pistons from two different suppliers (A and B). The acceptable tolerance of the length of a piston is to be 599.0” – 599.5”. Based on this information and the data provided, answer the following questions:
-
- What is the probability that a piston will meet tolerance, regardless of supplier?
- What is the probability that a piston manufactured by Supplier A will meet tolerance?
- What is the probability that a piston manufactured by Supplier B will meet tolerance?
- Discuss your results and propose a path forward.