1
$\begingroup$

I have daily sales data from 2011 to 2013. I have to do prediction for 2014.I have used arima and exponential method to predict the daily sale, but it is not giving the better result. MAPE is around 25%.

y=ts(x,frequency=7)

fit <- auto.arima(y)

fc <- forecast(fit, h=265)

plot(fc)

fit <- ets(y)

fc <- forecast(fit,h=265)

Below is the link for data:

https://drive.google.com/file/d/0B5en_TDcZWi3QWNjMzd3ZkdIcW8/edit?usp=sharing

Is there a way to improve the MAPE? I am new to time series,I would appreciate any kind of help.

Improve this question
$\endgroup$
2
  • $\begingroup$ What country is the data from as holidays can have an impact? What type of data is it? $\endgroup$
    – Tom Reilly
    Jul 20, 2014 at 13:33
  • $\begingroup$ It is a daily sales data of a store. The country is US. I tried using holiday also. Still getting the same MAPE $\endgroup$
    – Arushi
    Jul 20, 2014 at 16:44

1 Answer 1

Reset to default
1
$\begingroup$

I looked closely at your data and the 2014 data is much much lower and couldn't have been predicted to be that low. Every January to March is high in the historical data and the model can't be blamed for this massive shift downwards. What you need to do is consider the MAPE at many different origins not one. When you do that you will see that as the first observations in 2014 data are lower that the model respond to the lower level of the data and your MAPE will get better.

Improve this answer
$\endgroup$
2
  • $\begingroup$ "MAPE at many different origins not one", could you please explain this sentence? I am getting it. Thanks. $\endgroup$
    – Arushi
    Jul 22, 2014 at 8:02
  • 1
    $\begingroup$ It means that you need to look at forecasts from today, tomorrow, the next day and then calculate a WMAPE(weighted) and not just from one point in time. $\endgroup$
    – Tom Reilly
    Jul 23, 2014 at 13:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.