Explore BrainMass
Share

Correlation and Regression

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Bus and subway ridership for the summer months in Paris, France, is believed to be tied heavily to the number of tourists visiting the city. During the past 12 years, the following data have been obtained:

Year(summer months) Number of Tourists(millions) Ridership(millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7

a) Plot these data and decide if a linear model is reasonable.
b) Develop a regression relationship.
c) What is expected ridership if 10 million tourists visit Paris in a year?
d) Explain the predicted ridership if there are no tourists at all.
e) What is the standard error of the estimate?
f) What is the model's correlation coefficient and coefficient of determination?

Work must be completed in Excel.

© BrainMass Inc. brainmass.com December 20, 2018, 3:00 am ad1c9bdddf
https://brainmass.com/business/strategy-and-business-analysis/correlation-and-regression-241028

Solution Summary

Develops a regression equation and determines the standard error, coefficient of correlation and coefficient of determination.

$2.19