Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is "Adjusted R^2" in Multiple Regression
Hi there.
When performing multiple regressions, Excel 2000 reports a regression statistic that I am not familiar with. I know what R^2 is, but does anyone know what Adjusted R^2 is? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is "Adjusted R^2" in Multiple Regression
R squared is the pearson product squared. It refers to goodness of fit of the
line to the actual points of data. The value will be between 1 and 0 with higher numbers being better. Note that regression will always generate a line. Whether that line indicates a trend or not is another matter. -- HTH... Jim Thomlinson " wrote: Hi there. When performing multiple regressions, Excel 2000 reports a regression statistic that I am not familiar with. I know what R^2 is, but does anyone know what Adjusted R^2 is? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is "Adjusted R^2" in Multiple Regression
poster1234us -
R-Square (R^2) is the proportion of variation in the dependent variable (Y) that can be explained by the predictors (X variables) in the regression model. As predictors (X variables) are added to the model, each predictor will explain some of the variance in the dependent variable (Y) simply due to chance. One could continue to add predictors to the model which would continue to improve the ability of the predictors to explain the dependent variable, although some of this increase in R-Square would be simply due to chance variation. The adjusted R-Square attempts to yield a more honest value to estimate R-Square. Adjusted R-Square is computed using the formula 1-((1-R^2)*(N-1)/(N-k-1)). When the number of observations (N) is small and the number of predictors (k) is large, there will be a much greater difference between R-Square and adjusted R-Square (because the ratio of (N-1)/(N-k-1) will be much less than 1). By contrast, when the number of observations is very large compared to the number of predictors, the value of R-Square and adjusted R-Square will be much closer because the ratio of (N-1)/(N-k-1) will approach 1. - Mike www.mikemiddleton.com wrote in message oups.com... Hi there. When performing multiple regressions, Excel 2000 reports a regression statistic that I am not familiar with. I know what R^2 is, but does anyone know what Adjusted R^2 is? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is "Adjusted R^2" in Multiple Regression
Thanks, Mike. That was a big help.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Regression R^2 Issue | Excel Discussion (Misc queries) | |||
multiple regression in Excel12 | Excel Worksheet Functions | |||
How do I put days of the week into a multiple regression model? | Excel Worksheet Functions | |||
How do I perform multiple regression in Excel using two independe | Excel Worksheet Functions | |||
multiple regression | New Users to Excel |