Question: City Hospital would like to develop a regression model to predict the total hospital bill for a patient based on his or her length of
City Hospital would like to develop a regression model to predict the total hospital bill for a patient based on his or her length of stay, number of days in the hospital's intensive care unit (ICU), and age of the patient. Data for these variables can be found in the Excel file City Hospital.xlsx. (Picture has been attached)
?a. Construct a regression model using all three independent variables.
b. Interpret the meaning of the regression coefficients.
c. Predict the average hospital bill for a 53-year-old person hospitalized for three days with no days spent in the ICU.
d Construct a 95% confidence interval for the average hospital bill for the patient in part c
e. Construct a 95% prediction interval for the hospital bill for the patient in part c.

Costs ($) Age Days 1438 20 1950 38 2728 33 2849 28 3175 37 3609 24 3966 28 4318 45 4700 28 4914 39 5102 28 5813 35 6311 48 6598 28 6738 31 6944 22 7723 26 9809 62 IN 9052 30 8048 50 N 8056 43 8221 31 8479 21 9305 21 9441 41 10628 39 9689 39 10104 72 10596 24 N 10775 72 12215 35 1 00 A 12419 46 12592 29 12621 75 13034 36 13281 81 13580 69 13647 35 18457 53 12 N WOWHOONOHONOHOOOHOOOOO 16978 56 5 V 18392 41 10 18759 87 17393 51 20554 46 14560 38 11 28596 57 00 28804 62 16 22514 51 9 32660 49 14 34460 71 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
