ISOM 201

ISOM

### Question Description

I need help with a Excel question. All explanations and answers will be used to help me learn.

Need to finish it in excel file.

Pls answer the question separately.

**homework 4**

The total expenses of a hospital are related to many factors. Two of these factors are the number of beds in the hospital and the number of admissions. Data were collected on 14 hospitals, as shown in the above table.

a) Develop a regression model that could be used to predict the total expenses based on the number of beds.

b) Develop a regression model that could be used to predict the total expenses based on the total admissions

c) Develop a regression model that could be used to predict the total expenses based on the number of beds, and total admissions

d) Specify the best regression model that can be used to predict the number of victories

e) Discuss the accuracy of the regression model you specify in section d, and the significance of independent variables

f) Develop a regression model that could be used to predict the total expenses based on the total admissions, and number of beds with confidence level of 90%

g) Compare the result of model you developed in section (f) and section (c) in terms of

- significance of predictors

- sign of coefficient

- adjusted r-square

**homework 4**

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final Answer

Here it is :)

Chapter 4 homework 4

The total expenses of a hospital are related to many factors. Two of these factors are the number of beds

in the hospital and the number of admissions. Data were collected on 14 hospitals, as shown in the above

table.

a) Develop a regression model that could be used to predict the total expenses based on the

number of beds.

𝑦 = 0.3014𝑥1 − 4.1941, where 𝑥1 = the number of beds

b) Develop a regression model that could be used to predict the total expenses based on the total

admissions.

𝑦 = 0.6686𝑥2 + 1.5181, where 𝑥2 = the total number of admissions

c) Develop a regression model that could be used to predict the total expenses based on the

number of beds, and total admissions

𝑦 = 0.0231𝑥1 + 0.6230𝑥2 + 0.6539, where 𝑥1 = the number of beds and 𝑥2 = the total number of

admissions

d) Specify the best regression model that can be used to predict the number of vict...