Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Discrete Mathematics

Authors: Gary Chartrand, Ping Zhang

1st Edition

1478616261, 9781478616269

More Books

Students also viewed these Mathematics questions

Question

Describe the major bond market participants. (LG 6-3) LO.1

Answered: 1 week ago

Question

7. How can an interpreter influence the utterer (sender)?

Answered: 1 week ago