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 ::