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.

#### Solution Summary

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

\$2.19
Similar Posting

## Linear Correlation, Regression Lines and Measures of Variation

1) Testing for a Linear Correlation
Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from the table below using a=0.05. Determine whether the is sufficient evidence to support a claim of a linear correlation between the two variables.

Airline Fares Listed below are the costs (in dollars) of flights from New York (JFK) to San Francisco for US Air, Continental, Delta, United, American, Alaska, and Northwest. Use a 0.05 significance level to test the claim that there is no difference in cost between flights scheduled one day in advance and those scheduled 30 days in advance. What appears to be a wise scheduling strategy?

Flight scheduled 30 days advance 244 260 264 264 278 318 280
Fight scheduled one day in advance 456 614 567 943 628 1088 536
Create scatter plot

2) Finding the Equation of the Regression Line and Making Predictions
In each case, find the regression equation, letting the first variable be the predictor (x) variable. Find the indicated predicted value by following the prediction procedure summarized in
CPI and Subway Fare ; Find the best predicted cost of a slice of pizza when the consumer price index is 182.5 in the year 2000

CPI 30.2 48.3 112.3 162.2 191.9 197.8
Pizza 0.15 0.35 1.00 1.35 1.50 2.00

3) Finding the Equation of the Regression Line and Making Predictions
In each case, find the regression equation, letting the first variable be the predictor (x) variable. Find the indicated predicted value by following the prediction procedure summarized in

Commuters and Parking Space The Metro-North Station of Greenwich, CT has 2804 commuters . Find the best predicted number of parking spots at that station. Is the predicted value close to the actual value of 127?

Commuters 3453 1350 1126 3120 2641 277 579 2532
Parking Spots 1653 676 294 950 1216 179 466 1454

4) Finding Measures of Variation
Find (a) explained variation, (b) unexplained variation,(c) total variation, (d) coefficient of determination,and (e) standard error of estimate Se, In each case, there is sufficient evidence to support a claim of a linear correlation so that it is reasonable to use the regression equation when making predictions

CPI and Subway Fare The consumer price index and the cost of a slice of pizza from table 10-1
CPI 30.2 48.3 112.3 162.2 191.9 197.8
Pizza 0.15 0.35 1.00 1.25 1.75 2.00

View Full Posting Details