Regression variables

Excel Help for regression variables in Excel Multiple Regression Analysis and Forecasting Template

Find Excel Solutions


Search the Forums:
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel




Follow Business Spreadsheets On:
 
Forum TopicReply Login
regression variables
Rate this:
(3/5 from 1 vote)
AngryHi,
i am doing regression analysis which has the following independent variables

Total Time the department has worked for a month
Efficiency(%)

the problem is i wanted to include number of employees also so as to reflect the sudden change in number of employees in a department but as it is evident the problem of multi collinearity creeps in! 
pls help :)

 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
The multi-colinearity simple means that the variable in question is descriptive of itself. This does not mean that it is irrelevant for predicting the dependent variable. You can choose to run with the analysis anyway for your purposes.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for regression variables in the

 
Find Excel templates
and add-ins in the
Excel Business Solutions Directory
       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us