Forecasting using ARTXP algorithm using "Data mining" add-in in excel

Vote count:

0

Am trying to build a predictive model in excel using "Data mining" add-in.

Month       Temp    Sales
201301  40.7    60
201302  43.4    60
201303  46.2    70
201304  50.2    75
201305  55.8    105
201306  60.7    125
201307  65.3    145
201308  65.7    120
201309  61.1    95
201310  52.7    60
201311  45.2    55
201312  40.7    85

Above is the sample data set , i am using ARTXP time series model option. i am able to forecast. but i want a dynamic model, Ex: when i change the factor "Temp" my "sales" values should accordinlgy get forecasted.

Can anyone please help me on this.

asked 41 secs ago

user3243383

1

Forecasting using ARTXP algorithm using "Data mining" add-in in excel