A hospital would like to develop a regression model to predict the total hospital bill for a patient based on the age of the patient (x1), his or her length of stay (x2), and the number of days in the hospital's intensive care unit(ICU) (x3). Data for these variables can be found in Q4data.xlsx. Complete parts a through e below.

a) Construct a regression model using all three independent variables. (Round to the nearest whole number as needed.)

b) Interpret the meaning of the regression coefficients.

c) Predict the average hospital bill for a 69-year-old person hospitalized for ten days with no days spent in the ICU. (Round to the nearest dollar as needed.)

d) Construct a 95% confidence interval for the average hospital bill for the patient described in part c. (Round to the nearest dollar as needed.)

e) Construct a95% prediction interval for the average hospital bill for the patient described in part c, that is, a 69-year-old person hospitalized for ten days with no days spent in the ICU. (Round to the nearest dollar as needed.)

Below is the excel table given. (The pics may be out of order. However, the numbers of the rows showing the order are on the left.)

Thank you!!! (:

\f\f\f