Question

Question 4 (25pts) 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 a 95% 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.)

please show work, attached is the data

Answer 1

Answer: a b)x for - 6048 + 8) + 114.(x2) +673 (x2) Every altitional of patent, - the bill was incoeased by 47 8. fo Every adlitional length of stry of a patient, the bill call incareose by 147 * fa every additional tength of slayin nou of a pation, the bill will increase by 673 Y = 18060 d) The 95t confidence interval is behoren & 11636 and $24485 e) The a57 prediction interval is blo $996 $85824. and