# 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 3, 2020, 7:23 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/plot-the-data-and-determine-if-a-linear-model-is-reasonable-96437

#### 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