Explore BrainMass
Share

Regression and Correlation

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 August 19, 2018, 3:15 am ad1c9bdddf

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.19