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. 
(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?
Definitions:
Q31: The variable to be predicted is the
Q36: A dry cleaning business offers a pick-up
Q42: Which of the following is not an
Q44: The number of cell phone minutes used
Q59: A professional baseball organization chooses to sell
Q65: An air conditioning and heating repair firm
Q95: Barbour Electric is considering the introduction of
Q98: The maximin decision criterion is used by
Q112: The Hurwicz criterion is also called the
Q121: Compute the F value based on the