Previous Page     Back to Beginning

Here it is...

Formatted

In one shot, we have just about everything we need to know. The correlation coefficient is 0.86, R-squared is 75% and the regression equation is MPG-hat = 47.03 - 0.008(Weight). The residual plot shows one unusual point but there's no apparent pattern the rest of the points and it looks sufficiently linear.

What's missing? There's no scatter plot. That's the one thing the Regression tool doesn't do. Therefore, some people like to use Excel's Charts to get the scatter plot and the Regression tool for everything else.

Return to Main Excel Regression Page