Explore BrainMass

Explore BrainMass

    Plot the Data and Determine if a Linear Model is Reasonable

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

    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 ad1c9bdddf
    https://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

    ADVERTISEMENT