Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,939
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default What is "Adjusted R^2" in Multiple Regression

Thanks, Mike. That was a big help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Regression R^2 Issue DigitalDuck Excel Discussion (Misc queries) 4 June 7th 06 04:34 AM
multiple regression in Excel12 The Hern Excel Worksheet Functions 2 March 13th 06 09:53 PM
How do I put days of the week into a multiple regression model? Paula Excel Worksheet Functions 2 February 6th 06 10:34 AM
How do I perform multiple regression in Excel using two independe Freda Excel Worksheet Functions 2 November 29th 05 05:59 PM
multiple regression September21 New Users to Excel 5 September 25th 05 11:48 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"