A sU an hotel derives Its evenue from its notel and res 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.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter5: Linear Inequalities
Section: Chapter Questions
Problem 4SGR
icon
Related questions
Topic Video
Question
100%
Day  Revenue Occupied
1 1452 32
2 1361 20
3 1426 21
4 1470 25
5 1456 26
6 1430 23
7 1354 20
8 1442 39
9 1394 15
10 1459 50
11 1399 41
12 1458 35
13 1537 41
14 1425 31
15 1445 51
16 1439 62
17 1348 45
18 1450 41
19 1431 62
20 1446 47
21 1485 43
22 1405 38
23 1461 36
24 1490 60
25 1426 65
BUSU610ExcelAssignment#7 (2) - Excel
À Gregg Fells
AutoSave
Search
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
P Comments
E Split
CD View Side by Side
A
Default
M Ruler
V Formula Bar
ZHide
D[ Synchronous Scrolling
Normal Page Break Page Custom
Preview Layout Views
H Keep e Exit New E Options
V Gridlines v Headings
Zoom 100% Zoom to
New Arrange Freeze
Switch
Macros
Selection
Window
All
Panes v OUnhide
CO Reset Window Position
Windows
Sheet View
Workbook Views
Show
Zoom
Window
Macros
F9
fe
F
PART I : A suburban hotel derives its revenue from its hotel and restaurant
1
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.
2
3
4
1) Does the revenue seem to increase as the number of occupied rooms
increases? Draw a scatter diagram to support your conclusion.
7
2) Determine the correlation coefficient between the two variables.
|Interpret the value.
9.
10
3) Is it reasonable to conclude that there is a positive relationship between
revenue and occupied rooms? Use the .10 significance level.
11
Task 1
Task 2
+
Ready
囲
200%
LO
CO
Transcribed Image Text:BUSU610ExcelAssignment#7 (2) - Excel À Gregg Fells AutoSave Search File Home Insert Page Layout Formulas Data Review View Help A Share P Comments E Split CD View Side by Side A Default M Ruler V Formula Bar ZHide D[ Synchronous Scrolling Normal Page Break Page Custom Preview Layout Views H Keep e Exit New E Options V Gridlines v Headings Zoom 100% Zoom to New Arrange Freeze Switch Macros Selection Window All Panes v OUnhide CO Reset Window Position Windows Sheet View Workbook Views Show Zoom Window Macros F9 fe F PART I : A suburban hotel derives its revenue from its hotel and restaurant 1 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. 2 3 4 1) Does the revenue seem to increase as the number of occupied rooms increases? Draw a scatter diagram to support your conclusion. 7 2) Determine the correlation coefficient between the two variables. |Interpret the value. 9. 10 3) Is it reasonable to conclude that there is a positive relationship between revenue and occupied rooms? Use the .10 significance level. 11 Task 1 Task 2 + Ready 囲 200% LO CO
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Discrete Probability Distributions
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.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Elementary Linear Algebra (MindTap Course List)
Elementary Linear Algebra (MindTap Course List)
Algebra
ISBN:
9781305658004
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL