Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > R-Square, Adjusted R-Sqaure, Multicollinearity, and Autocorrelation Share

R-Square, Adjusted R-Sqaure, Multicollinearity, and Autocorrelation

Excel Help for R-square, Adjusted R-sqaure, Multicollinearity, And Autocorrelation in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

R-square, Adjusted R-sqaure, Multicollinearity, And Autocorrelation

Rate this:
(3/5 from 1 vote)
Confused Hello,
Kindly help explain the R-Square and Adjusted R-Square figures associated with each of the independent variables. Also, how do you you determine from the R-Square and Adjusted R-Square, which of the variables to add or exclude?

You can also help explain the aspect of multcollinearity and autocorrelation for each of the independent variables. 

Best Regards,
Segun.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
The R-squared measures the extent to which the independent variables explains the dependent variable.

Adjusted R-squared takes into account the number of independent variables and is therefore more reliable.

Look at the help icons for multicollinearity and autocorrelation as they address relationships between independent variables.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for R-Square, Adjusted R-Sqaure, Multicollinearity, and Autocorrelation in the