Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(4 points) Problems: A manager of a hotel chain was interested in investigating if there is a relationship between monthly labor hours and the number

image text in transcribed
(4 points) Problems: A manager of a hotel chain was interested in investigating if there is a relationship between monthly labor hours and the number of beds occupied in the hotel. The ofcer randomly selected 17 of the hotels in the chain across the country and recorded, for each of these hotels, the monthly labor hours required during the month of July and the number of bed days occupied for that month. (A hotel has occupied one \"bed day\" if one bed is \"occupied\" for an entire day.) The ofcer is interested in seeing if the labor hours required can be predicted from the number of bed days occupied on a monthly basis. The sample data were analyzed in Excel. Included below is part of the regression analysis output. SUMMARY OUTPUT Regression Statistics Multiple R 0.985992834 R Square 0.972181869 Adjusted Fl Square 0.970327327 Standard Error 957.8414089 Observations 17 ANOVA df 88 MS F Significance F Regression 1 480947920 480947920 524.2166783 4.41082E-13 Residual 15 1376190247 917460.1646 Total 1 6 4947098224 Coefcients Standard Error t Stat P-vaiue Intercept -28.105881 319.0363754 0088096164 0930965629 Bed Days 1.117389432 0.048803295 22.89577861 4.41082E13 (Note: Use the above scenario and the Excel analysis given above to answer Questions a d) a For the estimated regression equation y = a + bx, what is the value of b? (1 point)

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 and Combinatorial Mathematics An Applied Introduction

Authors: Ralph P. Grimaldi

5th edition

201726343, 978-0201726343

More Books

Students also viewed these Mathematics questions