The distance (in kilometers) and price (in dollars) for one-way airline tickets from City A to several cities   are shown in the table. (you may use excel to perform the calculations)   Destination Distance (km) Price ($) City B 2387 232 City C 4523 399 City D 1035 159 City E 2290 155 City F 3875 290   Find the correlation coefficient for this Use distance as the x -variable and price as the y-variable. Recalculate the correlation coefficient for this data using price as the x-variable and distance as the y-variable. What effect does this have on the correlation coefficient?  Suppose a $25 security fee was added to the price of each What effect would this have on the correlation coefficient?  Suppose the airline had a sale where all ticket prices decreased by 50%. What effect would this have on the correlation coefficient?

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

The distance (in kilometers) and price (in dollars) for one-way airline tickets from City A to several cities   are shown in the table. (you may use excel to perform the calculations)

 

Destination

Distance (km)

Price ($)

City B

2387

232

City C

4523

399

City D

1035

159

City E

2290

155

City F

3875

290

 

  1. Find the correlation coefficient for this Use distance as the x -variable and price as the y-variable.
  2. Recalculate the correlation coefficient for this data using price as the x-variable and distance as the y-variable. What effect does this have on the correlation coefficient? 
  3. Suppose a $25 security fee was added to the price of each What effect would this have on the correlation coefficient? 
  4. Suppose the airline had a sale where all ticket prices decreased by 50%. What effect would this have on the correlation coefficient? 

 

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON