Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Independent variables - % change v/s absolute value Share

Independent variables - % change v/s absolute value

Excel Help for Independent Variables - % Change V/s Absolute Value in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Independent Variables - % Change V/s Absolute Value

Rate this:
(3/5 from 1 vote)
ConfusedHi,

I have a question on input data - independent variables. I have multiple time series as my input data, with some in % change form and the other in absolute value. My dependent variable time series is in absolute value form as well. Is it ok to have independent variable time series in 2 different forms - % change and absolute number? Should I change (manually) all the independent variables to % change form? My reasoning for keeping both forms is that some variables are index values while others are month over month changes.

Looking forward to your reply.

Thanks,
Hanu
 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)
You can keep the format of the independent values and have some in percentages and some in absolute values.  Bear in mind that you will need to enter dats in the same formats in the forecast to be consistent with the regression equation.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Independent variables - % change v/s absolute value in the