+ Reply to Thread
Results 1 to 5 of 5

Thread: The best formula to use in excel to forecast daily call volume?

  1. #1
    Points: 258, Level: 5
    Level completed: 16%, Points required for next Level: 42

    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts

    The best formula to use in excel to forecast daily call volume?




    I have used single and double exponential smoothing, but did not know if there is a more accurate approach to predict how many calls that can be expected.

  2. #2
    Devorador de queso
    Points: 95,819, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Awards:
    Posting AwardCommunity AwardDiscussion EnderFrequent Poster
    Dason's Avatar
    Location
    Tampa, FL
    Posts
    12,935
    Thanks
    307
    Thanked 2,629 Times in 2,245 Posts

    Re: The best formula to use in excel to forecast daily call volume?

    Single and double exponential smoothing don't account for seasonality. If your call volume seasonal in nature? If so then if you wanted to stay in the exponential smoothing family you'll need to use at least *triple* exponential smoothing.
    I don't have emotions and sometimes that makes me very sad.

  3. The Following User Says Thank You to Dason For This Useful Post:

    mdo8105 (10-07-2015)

  4. #3
    TS Contributor
    Points: 14,811, Level: 78
    Level completed: 91%, Points required for next Level: 39
    Miner's Avatar
    Location
    Greater Milwaukee area
    Posts
    1,171
    Thanks
    34
    Thanked 405 Times in 363 Posts

    Re: The best formula to use in excel to forecast daily call volume?

    It depends on what components are in your time series (i.e., trends, seasonality, or cyclicity). Each approach has particular strengths and weaknesses in dealing with these components. For example, single and double exponential smoothing handle cyclicity, but not seasonality. Double handles trends, but single does not.


    Winters and ARIMA will handle all three, but add additional complexity (particularly ARIMA).

  5. The Following User Says Thank You to Miner For This Useful Post:

    mdo8105 (10-07-2015)

  6. #4
    Fortran must die
    Points: 58,790, Level: 100
    Level completed: 0%, Points required for next Level: 0
    noetsi's Avatar
    Posts
    6,532
    Thanks
    692
    Thanked 915 Times in 874 Posts

    Re: The best formula to use in excel to forecast daily call volume?

    Holt Winters will deal with seasonality and [I believe trend]. ARIMA won't deal with non-linear predictions and you have to have considerable expertise in practice to use it so sticking with some form of exponential smoothing like Winters or Holt Winters is probably desirable. Test of the various predictive methods show it has a good track record and its robust to assumptions.

    That said you have to provide more details including context to answer your question. Poison regression or some form of operations research (like queuing models) might predict call rates over time better than time series, particularly if you want to break up call volume in narrower periods of time like hours or minutes. Commonly that is what you use to predict this.
    "Very few theories have been abandoned because they were found to be invalid on the basis of empirical evidence...." Spanos, 1995

  7. The Following User Says Thank You to noetsi For This Useful Post:

    mdo8105 (10-07-2015)

  8. #5
    Points: 258, Level: 5
    Level completed: 16%, Points required for next Level: 42

    Posts
    21
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: The best formula to use in excel to forecast daily call volume?


    Thank ya'll for the insight. Right now I am using a multivariate regression to predict the call volume. I am taking my actual calls and and running the log function on them. I am using the log of the actual calls as my Y, then using Holt Winters to produce my Lt and then using the Lt with Mon-Fri (with dummy variables) and Jan through Sept (with Dummy variables) since excel will only allow 16 variables. With my predicted Y I am raising it by 9.8. I tried raising with the base of 10, but found better accuracy with 9.8. I am running an 8 percent MAPE with this equation, but so far for this week I have been sitting at 1 percent MAPE. Does anyone have any ideas on how to better increase the accuracy?

    Thank you

+ Reply to Thread

           




Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats