Solved

Bob White Is Conducting Research on Monthly Expenses for Medical

Question 38

Essay

Bob White is conducting research on monthly expenses for medical care, including over the counter medicine.His dependent variable is monthly expenses for medical care while his independent variables are number of family members and insurance type (government funded, private insurance and other).He has coded insurance type as the following:
X2 = 1 if government funded, X3 = 1 if private insurance
Below is his Excel output.
Bob White is conducting research on monthly expenses for medical care, including over the counter medicine.His dependent variable is monthly expenses for medical care while his independent variables are number of family members and insurance type (government funded, private insurance and other).He has coded insurance type as the following: X2 = 1 if government funded, X3 = 1 if private insurance Below is his Excel output. ANOVA (a)What is the prediction equation? (b)Based on the significance F-test, is this model a good prediction equation? (c)What percent of the variation in medical expenses is explained by the independent variables? (d)Based on his model, what are the predicted monthly expenses for a family of four with private insurance? (e)Based on his model, what are the predicted monthly expenses for a family of two with government funded insurance? (f)Based on his model, what are the predicted monthly expenses for a family of five with no insurance? ANOVA
Bob White is conducting research on monthly expenses for medical care, including over the counter medicine.His dependent variable is monthly expenses for medical care while his independent variables are number of family members and insurance type (government funded, private insurance and other).He has coded insurance type as the following: X2 = 1 if government funded, X3 = 1 if private insurance Below is his Excel output. ANOVA (a)What is the prediction equation? (b)Based on the significance F-test, is this model a good prediction equation? (c)What percent of the variation in medical expenses is explained by the independent variables? (d)Based on his model, what are the predicted monthly expenses for a family of four with private insurance? (e)Based on his model, what are the predicted monthly expenses for a family of two with government funded insurance? (f)Based on his model, what are the predicted monthly expenses for a family of five with no insurance? Bob White is conducting research on monthly expenses for medical care, including over the counter medicine.His dependent variable is monthly expenses for medical care while his independent variables are number of family members and insurance type (government funded, private insurance and other).He has coded insurance type as the following: X2 = 1 if government funded, X3 = 1 if private insurance Below is his Excel output. ANOVA (a)What is the prediction equation? (b)Based on the significance F-test, is this model a good prediction equation? (c)What percent of the variation in medical expenses is explained by the independent variables? (d)Based on his model, what are the predicted monthly expenses for a family of four with private insurance? (e)Based on his model, what are the predicted monthly expenses for a family of two with government funded insurance? (f)Based on his model, what are the predicted monthly expenses for a family of five with no insurance? (a)What is the prediction equation?
(b)Based on the significance F-test, is this model a good prediction equation?
(c)What percent of the variation in medical expenses is explained by the independent variables?
(d)Based on his model, what are the predicted monthly expenses for a family of four with private insurance?
(e)Based on his model, what are the predicted monthly expenses for a family of two with government funded insurance?
(f)Based on his model, what are the predicted monthly expenses for a family of five with no insurance?

Correct Answer:

verifed

Verified

(a)Y = 144.91 + 11.63X1 - 13.70 X2 - 9.11X...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q33: A healthcare executive is using regression to

Q34: In regression, there is random error that

Q35: Explain the purposes of regression models.

Q36: If computing a causal linear regression model

Q37: Which of the following statements is false

Q39: Suppose that you believe that a cubic

Q40: The correlation coefficient has values between −1

Q41: In a good regression model the residual

Q42: There is no relationship between variables unless

Q43: Often, a plot of the residuals will