How does Excel calculate Multiple R when doing multiple regression

W

whobell

I am trying to determine how Excel calculates the statistic Multiple R (the
first statistic listed in the Regression Statistics box) when one is doing
multiple regression. I know that when doing simple regression, this number
is just the correlation coefficient. But I'm not quite sure what is being
calculated when doing multiple regression.
 
M

Mike Middleton

whobell -

For both simple and multiple regression, to get Excel's "Multiple R,"
compute the ratio of SS Regression divided by SS Total, and then take the
square root.

SS Regression and SS Total are shown in the ANOVA section of the Regression
tool output.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is "Adjusted R^2" in Multiple Regression 3
Regression Statistics are returned as Rounded to 1 vs. several dec 2
How do I perform multiple regression in Excel using two independe 2
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
multiple polynomial regression in Excel 4
Regression gives slope of zero when x values smaller than 10^-7 2
Multiple (as in many) regressions 3
Multiple Regression R^2 Issue 4

Top