Excel Help for 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

Rate this:

(3/5 from 1 vote)

	Hi, 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 hanm on 19 Aug 2009

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	Keep formats Rate this: (4/5 from 2 votes) 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 Excel Helper on 19 Aug 2009

Displaying page 1 of 1

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

Independent variables - % change v/s absolute value