Share
Explore BrainMass

Plot the Data and Determine if a Linear Model is Reasonable

Year Number of tourists (1,000,000's) Ridership (100,000's)
1 7 15
2 2 10
3 6 13
4 4 15
5 14 25
6 15 27
7 16 24
8 12 20
9 14 27
10 20 44
11 15 34
12 7 17

A. Plot these data and determine if a linear model is reasonable.

B. Develop a regression model.

C. What is the expected ridership if 10 million toursists visit the city.

D. If there are no tourists at all, expalin the predicted ridership.

Solution Preview

Please see the attached files.

a. Yes it looks like the linear model is reasonable after plotting in Excel:

b. Use ...

Solution Summary

The solution provides detailed discussion and explanations, including graphs in Excel, for the problem.

$2.19