A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. The dataset is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and the number of rooms occupied. 1) Does the revenue seem to increase as the number of occupied rooms increases? Draw a scatter diagram to support your conclusion.2) Determine the correlation coefficient between the two variables. Interpret the value. 3) Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the .10 significance level. 4) What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied? BUSU610ExcelAssignment#7 - ExcelO SearchA Gregg FellsAutoSaveOffFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsEInsert vΣ- 12 - A A"==a Wrap TextCalibriGeneralDX Delete vPasteBIU -On - A -=E= E EE E Merge & Center -$ - % 9 58 -98Conditional Format asCellSort & Find &IdeasSensitivity.00Formatting Table Styles vA Format vOv Filter v SelectClipboardFontAlignmentNumberStylesCellsEditingIdeasSensitivityA1CustomerABDEFHThe Cronch Café, located at the Gulf of Mexico, has an increase in business duringPART II TASKS: the summer vacation season. The owner hires a large number of servers as1Customer Amount of Tip ($) Amount of Bill ($) Dinersseasonal help. When he interviews a prospective server, he would like to providedata on the amount a server can earn in tips. He believes that the amount of the bill215.1574.52324.528.234and the number of diners are both related to the amount of the tip. He gathered thissample information.43110.65142.419.8236528.6231) Develop a multiple regression model with the amount of tips as the dependentvariable and the amount of the bill and the amount of diners as independent74.2524.83212 points870.56.25variables. (5 points) Write out the regression equation. (4 points) How much doesanother diner add to the amount of the tips? (3 points)9849.24.1043.2632) Conduct a global test of hypothesis to determine if at least one of the independent 8 pointsvariables is significant. (4 points) What is your conclusion? (4 points)11104.6562.23112115.684.811.1312634.9931413433.91415143.3523.06216150.754.65117163.323.59218173.522.3219183.2532220195.450.02421202.2517.6322214.3563.162322320.272Task 1Task 2囲100% BUSU610ExcelAssignment#7 - ExcelO SearchA Gregg FellsAutoSaveOffFileHomeInsertPage LayoutFormulasDataReviewViewHelpA ShareP CommentsEInsert vΣ- 12 - A A==a Wrap TextCalibriGeneralDX Delete vPasteen v A-CellBIU - -=E= EE O Merge & Center -$ - % 9 58 -98Conditional Format asA Format vSort & Find &IdeasSensitivityFormatting Table Styles vO v Filter v SelectClipboardFontAlignmentNumberStylesCellsEditingIdeasSensitivityA1feCustomerABCEFH10943.2632) Conduct a global test of hypothesis to determine if at least one of the independent 8 pointsvariables is significant. (4 points) What is your conclusion? (4 points)11104.6562.23112115.684.811.1312634.9931413433.91415143.3523.06216150.754.6517163.323.59218173.522.3219183.2532220195.450.02421202.2517.6322214.3563.1662322320.27224231.2519.53225243.2527.033262521.28227266.2543.38428275.628.12429282.526.25230296.8553.08731308.687.85832Task 1Task 2+囲100%

Answered: Image /qna-images/answer/178b6a8a-144a-42a8-8602-c90d3709df97.jpg

Answered: A suburban hotel derives its revenue…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Concept explainers

Question

A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. The dataset is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and the number of rooms occupied.

1) Does the revenue seem to increase as the number of occupied rooms increases? Draw a scatter diagram to support your conclusion.

2) Determine the correlation coefficient between the two variables. Interpret the value.

3) Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the .10 significance level.

4) What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied?

BUSU610ExcelAssignment#7 - Excel
O Search
A Gregg Fells
AutoSave
Off
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
P Comments
E
Insert v
Σ
- 12 - A A"
==
a Wrap Text
Calibri
General
DX Delete v
Paste
BIU -
On - A -
=E= E EE E Merge & Center -
$ - % 9 58 -98
Conditional Format as
Cell
Sort & Find &
Ideas
Sensitivity
.00
Formatting Table Styles v
A Format v
Ov Filter v Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ideas
Sensitivity
A1
Customer
A
B
D
E
F
H
The Cronch Café, located at the Gulf of Mexico, has an increase in business during
PART II TASKS: the summer vacation season. The owner hires a large number of servers as
1
Customer Amount of Tip ($) Amount of Bill ($) Diners
seasonal help. When he interviews a prospective server, he would like to provide
data on the amount a server can earn in tips. He believes that the amount of the bill
2
1
5.15
74.5
2
3
2
4.5
28.23
4
and the number of diners are both related to the amount of the tip. He gathered this
sample information.
4
3
1
10.65
1
4
2.4
19.82
3
6
5
28.62
3
1) Develop a multiple regression model with the amount of tips as the dependent
variable and the amount of the bill and the amount of diners as independent
7
4.25
24.83
2
12 points
8
7
0.5
6.25
variables. (5 points) Write out the regression equation. (4 points) How much does
another diner add to the amount of the tips? (3 points)
9
8
49.2
4.
10
43.26
3
2) Conduct a global test of hypothesis to determine if at least one of the independent 8 points
variables is significant. (4 points) What is your conclusion? (4 points)
11
10
4.65
62.23
1
12
11
5.6
84.81
1.
13
12
6
34.99
3
14
13
4
33.91
4
15
14
3.35
23.06
2
16
15
0.75
4.65
1
17
16
3.3
23.59
2
18
17
3.5
22.3
2
19
18
3.25
32
2
20
19
5.4
50.02
4
21
20
2.25
17.6
3
22
21
4.35
63.16
23
22
3
20.27
2
Task 1
Task 2
囲
100%

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Correlation, Regression, and Association$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions