Explore BrainMass

Explore BrainMass

    Scatter Plot Graph in Excel

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    (a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.(c) Interpret the fitted slope. (d) Is the intercept meaningful? Explain. (e) Interpret the R2.

    12.18 Portfolio Returns (%) on Selected Mutual Funds Portfolio
    Last Year (X) This Year (Y)
    11.9 15.4
    19.5 26.7
    11.2 18.2
    14.1 16.7
    14.2 13.2
    5.2 16.4
    20.7 21.1
    11.3 12.0
    − 1.1 12.1
    3.9 7.4
    12.9 11.5
    12.4 23.0
    12.5 12.7
    2.7 15.1
    8.8 18.7
    7.2 9.9
    5.9 18.9

    12.19 Number of Orders and Shipping Cost ShipCost
    Orders (X) ($) Ship Cost (Y)
    1,068 4,489
    1,026 5,611
    767 3,290
    885 4,113
    1,156 4,883
    1,146 5,425
    892 4,414
    938 5,506
    769 3,346
    677 3,673
    1,174 6,542
    1,009 5,088.

    See the attached file.

    © BrainMass Inc. brainmass.com October 2, 2022, 6:41 am ad1c9bdddf
    https://brainmass.com/statistics/scatter-plot/scatter-plot-trendline-regression-232575

    Attachments

    Solution Summary

    The solution examines scatter plot trendlines to determine the regression analysis.

    $2.49

    ADVERTISEMENT