Business Finance
ISOM 201 Suffolk University Data and Decision Analysis Regression Model Worksheet

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
 

Unformatted Attachment Preview

Expenses Hospital 1 Hospital 2 Hospital 3 Hospital 4 Hospital 5 Hospital 6 Hospital 7 Hospital 8 Hospital 9 Hospital 10 Hospital 11 Hospital 12 Hospital 13 Hospital 14 Beds 57 127 157 24 14 93 45 6 99 12 11 15 21 63 Admissions 215 336 520 135 35 210 140 90 410 50 65 42 110 305 77 160 230 43 9 155 53 6 159 18 16 29 28 98 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. 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 ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

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

svantass (386)
Carnegie Mellon University

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
I did not know how to approach this question, Studypool helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags