Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > R-Square, Adjusted R-Sqaure, Multicollinearity, and Autocorrelation | Share |
Forum Topic | Post Reply Login |
R-square, Adjusted R-sqaure, Multicollinearity, And Autocorrelation | Rate this: (3/5 from 1 vote) |
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 Segun Awode on |
Replies - Displaying 1 to 1 of 1 | Order Replies By: Most recent | Chronological | Highest Rated |
Rate this: (4/5 from 2 votes) 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 Excel Helper on |
Displaying page 1 of 1 |
Find relevant Excel templates and add-ins for R-Square, Adjusted R-Sqaure, Multicollinearity, and Autocorrelation in the Excel Business Solutions Directory |