4
$\begingroup$

I'm using a time-series model to do weekly forecasts on the number of incoming calls to a company. This variable has a weekly 'in-month' pattern and a monthly 'in year' pattern, and i have data from 2008-01-01 to 2012-08-31.

To explain it better: Mondays show peaks along weeks, and rainy months show peaks along the year.

My idea is to take the week-forecast point and 'distribute' it along the week days, using the weekly-pattern information.

What is a good technique to do this? Empirical density distributions maybe? My tools: R language.

Edit: Below, weekly forecasts using 2 different methods.

Results from tbats using the forecast package: enter image description here

Results from tslm using the forecast package: enter image description here

Improve this question
$\endgroup$

2 Answers 2

Reset to default
6
$\begingroup$

Your approach is one possibility.

On the other hand, call center forecasting is an active area of research, and there are many people working in this field. One standard way of doing this is adding additional seasonal components to seasonal Exponential Smoothing, so you have one component for yearly and one component for weekly seasonality. You could even go down to hourly data and add another component for intra-daily seasonality, since calls will arrive in different quantities during the morning, the lunch hour, the afternoon and the night. This article, along with the following comments, may help you. Or this one by the same author.

I recommend that you google for "call center forecasting". Electricity demand has similar issues with intra-weekly and intra-daily seasonality, so searching for keywords along this direction will also help.

Improve this answer
$\endgroup$
10
  • $\begingroup$ Thanks, i'll take a look. My week-based model gives good results, what i really need is a simple way to split the week-mean across the weekdays. $\endgroup$
    – Fernando
    Commented Nov 29, 2012 at 16:14
  • $\begingroup$ A simple way would be to calculate the percentage of each week's calls to arrive on Monday, on Tuesday etc., to exponentially smoothe this series for each day of the week and to reapply the result. $\endgroup$
    – Stephan Kolassa
    Commented Nov 29, 2012 at 16:20
  • $\begingroup$ You mean, use one weekly model to get the mean forecast, then apply the weights, OR build a separate model for each day o the week? Thanks! $\endgroup$
    – Fernando
    Commented Nov 29, 2012 at 16:23
  • $\begingroup$ The first alternative: forecast total weekly arrivals, and separately forecast the percentage of this total to arrive on Monday, Tuesday, etc. Then apply the forecasted percentages to the forecasted total. (Of course, the forecasted percentages will probably not add up exactly to 100%, so you will have to renormalize.) $\endgroup$
    – Stephan Kolassa
    Commented Nov 29, 2012 at 16:28
  • $\begingroup$ So for every daily point of my dataset, i can take the percentage based on the current week, to build a new historic. Right? And thanks again, i liked this solution. $\endgroup$
    – Fernando
    Commented Nov 29, 2012 at 16:36
3
$\begingroup$

Since you are working in R, you might try the dshw() or tbats() functions from the forecast package. dshw() implements Taylor's double seasonal Holt-Winters method (referred to be @Stephan) to handle both seasonal periods. tbats() is more general, and implements the TBATS model from De Livera, Hyndman and Snyder (JASA, 2011). DSHW is a special case of this.

Improve this answer
$\endgroup$
5
  • $\begingroup$ @fernando, do u mind sharing your code? $\endgroup$
    – user1471980
    Commented Nov 30, 2012 at 12:54
  • $\begingroup$ I got great results using tbats, but i have a question: right now i'm using tslm with rainfall data as a regressor, which works fine (see post images). About 70% of time, there's no rain, is a good idea to take the average between these 2 models? thanks! $\endgroup$
    – Fernando
    Commented Nov 30, 2012 at 13:08
  • $\begingroup$ @user1471980 The code is very simple, just check ?tbats or ?tslm. $\endgroup$
    – Fernando
    Commented Nov 30, 2012 at 15:57
  • $\begingroup$ @Rob, I used the xreg parameter in tbats, and the results were the same as the model without the regressor. Is this normal? Thanks! $\endgroup$
    – Fernando
    Commented Nov 30, 2012 at 19:32
  • $\begingroup$ @Fernando. tbats() does not have an xreg argument. If you include one it will be ignored. $\endgroup$
    – Rob Hyndman
    Commented Dec 1, 2012 at 0:19

Your Answer

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

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