Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > regression variables Share

Regression variables

Excel Help for Regression Variables in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply 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 2 of 2Order 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
Confused
Rate this:
(4/5 from 2 votes)
Regression allows researchers to predict or explain the variation in one variable based on another variable. Definitions: ❖ The variable that researchers are trying to explain or predict is called the response variable. It is also sometimes called the dependent variable because it depends on another variable.
Regards,
Rachel Gomez
Regression allows researchers to predict or explain the variation in one variable based on another variable. Definitions: ❖ The variable that researchers are trying to explain or predict is called the response variable. It is also sometimes called the dependent variable because it depends on another variable.Regression allows researchers to predict or explain the variation in one variable based on another variable. Definitions: ❖ The variable that researchers are trying to explain or predict is called the response variable. It is also sometimes called the dependent variable because it depends on another variable.
 rachel
 Posted by on
 Displaying page 1 of 1 

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