# Regression and Correlation

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

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