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.
a. Using PHStat, construct a regression model using all three independent variables.
b. Test the significance of each independent variable using α = 0.05.
c. Interpret the p value for each independent variable.
d. Construct a 95% confidence interval for the regression coefficients for the ICU variable and interpret the meaning.

Step by Step Solution

★★★★★

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Set x 1 Age x 2 Days x 3 ICU y462495113556x 1 1218626x 2 2213213x 3 b H 0 i 0 H 1 i 0 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

483-M-S-L-R (3212).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

A Buick dealership would like to develop a regression model that would predict the number of cars sold per month by a dealership employee based on the employees number of years of sales experience....

Jersey Shore Realtors would like to develop a regression model to help it set weekly rental rates for beach properties during the summer season in New Jersey. The independent variables for this model...

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),...

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, the number of days in the hospitals intensive care unit...

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 hospitals intensive care unit (ICU),...

Please show in excel how you get the VIF!!! or what formula to use Data Table \begin{tabular}{|c|c|c|c|} \hline 9052 & 30 & 6 & 1 \\ \hline 8048 & 50 & 2 & 0 \\ \hline 8056 & 43 & 4 & 0 \\ \hline...

New York Citys financial statements for the year ended June 30, 2013 report a relatively large number of component units. Among them are the New York City Health and Hospitals Corporation (HHC) and...

Select the incorrect statement from the following option: Melting point serves as the criteria of purity of a solid substance Impure sample of substance has different melting point Every pure solid...

Which of the following is true concerning SEP IRAs? Taxpayers with a SEP IRA must contribute for their employees. SEP IRAs allow only nondeductible contributions.

Problem M-4 (LO 5) Hedging both fixed and floating interest rates. Pasu International purchased a plant in Louisiana on December 31, 20X5, and financed $20,000,000 of the purchase price with a 5-year...

A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. / a. Develop a scatter diagram for these...

Companies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011, Hertz had 320,000 cars in service and annual revenue of...

To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based on rating factors such as ergonomics, portability, performance,...

Solution step by step The proportion of cell phone users with 4G contracts last year was 11: = 0.62. A Verizon executive thinks the proportion has increased this year. Suppose that from a random...

1. A company invests $1,000,000 at the beginning of the year. It adds another $250,000 at the end of the first quarter, withdraws $350,000 at the end of the second quarter, adds $145,000 at the end...

Moerdyk Corporation's bonds have a 10-year maturity, a 9.95% semiannual coupon, and a par value of $1,000. The going interest rate (rd) is 7.70%, based on semiannual compounding. What is the bond's...