Microsoft Office Tutorials and References

In Depth Information

Fig. 6.27 Final spreadsheet of correlation and simple linear regression including the summary

output for the data

Note the following problem with the summary output.

Whoever wrote the computer program for this version of Excel

made a mistake and gave the name: ‘‘Multiple R’’ to cell A53.

This is not correct. Instead, cell A53 should say: ‘‘correlation r’’

since this is the notation that we are using for the correlation between X and Y.

You can now use your printout of the regression analysis to ﬁnd the regression

equation that is the best-ﬁtting straight line through the data points.

Search JabSto ::

Custom Search