Explore BrainMass
Share

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.

© BrainMass Inc. brainmass.com June 20, 2018, 7:14 am ad1c9bdddf

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