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.

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