Explore BrainMass

Explore BrainMass

    Regression and Correlation

    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!

    11. A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:

    Speed MPG

    44 22
    51 26
    48 21
    60 28
    66 33
    61 32

    a. Plot these data in a scatter diagram.
    b. Compute the coefficient of correlation.
    c. Determine the regression equation.

    © BrainMass Inc. brainmass.com March 4, 2021, 9:21 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/statistics-regression-correlation-237098

    Solution Preview

    ** Please see the attached Excel file. **

    Speed MPG
    44 22
    51 26
    48 21
    60 28
    66 33
    61 32

    a. Plot these data in a scatter diagram.

    Go to insert --> chart.
    Choose XY ...

    Solution Summary

    This solution shows how to create a scatter diagram, compute the coefficient of correlation, and determine the regression equation in Excel for the given problem.

    $2.49

    ADVERTISEMENT