Travel + Leisure  magazine presented its annual list of the 500 best hotels in the world. The magazine provides a rating for each hotel along with a brief description that includes the size of the hotel, amenities, and the cost per night for a double room. A sample of 12 of the top-rated hotels in the United States follows. Location Rooms Cost/Night Phoenix, AZ 220 499 Orlando, FL 727 340 Los Angeles, CA 285 585 Boston, MA 273 495 Washington DC 145 495 Ashville, NC 213 279 Phoenix, AZ 398 279 Island of Hawaii 343 455 Laguna Beach, CA 250 595 Chicago, IL 414 367 Dana Point, CA 400 675 Colorado Springs, CO 700 420 What is the sample correlation coefficient? What does it tell you about the relationship between the number of rooms and the cost per night for a double room? Does this appear reasonable? Discuss. Please show steps in Excel.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter1: Expressions And Functions
Section1.5: Descriptive Modeling And Accuracy
Problem 11PPS
icon
Related questions
Question

Travel + Leisure  magazine presented its annual list of the 500 best hotels in the world. The magazine provides a rating for each hotel along with a brief description that includes the size of the hotel, amenities, and the cost per night for a double room. A sample of 12 of the top-rated hotels in the United States follows.

Location Rooms Cost/Night
Phoenix, AZ 220 499
Orlando, FL 727 340
Los Angeles, CA 285 585
Boston, MA 273 495
Washington DC 145 495
Ashville, NC 213 279
Phoenix, AZ 398 279
Island of Hawaii 343 455
Laguna Beach, CA 250 595
Chicago, IL 414 367
Dana Point, CA 400 675
Colorado Springs, CO 700 420

What is the sample correlation coefficient? What does it tell you about the relationship between the number of rooms and the cost per night for a double room? Does this appear reasonable? Discuss. Please show steps in Excel.

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell