Hi Guys,
I am a bit confused about the Forecast function in excel.
I want to forecast per our interval of a call volume for a specific month
Now I've use this formula =FORECAST(AH5,B5:AF5,$B$4:$AF$4) wherein the constant value of AH5 is 1.
I'm I using the correct formula for the constant value of 1? The only sample I can get from google is that the forecast function being used to forecast vertically, what I wanted to to is horizontally.
Now if the formula I've used is not correct can you please assist me in correcting it?
Thanks much!
<colgroup><col width="96" span="2" style="width:72pt"> <col width="96" span="30" style="width:72pt"> </colgroup><tbody>
</tbody>
I am a bit confused about the Forecast function in excel.
I want to forecast per our interval of a call volume for a specific month
Now I've use this formula =FORECAST(AH5,B5:AF5,$B$4:$AF$4) wherein the constant value of AH5 is 1.
I'm I using the correct formula for the constant value of 1? The only sample I can get from google is that the forecast function being used to forecast vertically, what I wanted to to is horizontally.
Now if the formula I've used is not correct can you please assist me in correcting it?
Thanks much!
Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | |
Interval | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |
00:00 - 00:59 | 1 | 1 | 2 | 3 | 2 | 1 | 3 | 2 | 1 | 3 | 0 | 1 | 2 | 3 | 0 | 0 | 6 | 1 | 0 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 3 | 3 | 0 | 1 | 2 |
01:00 - 01:59 | 2 | 0 | 1 | 2 | 1 | 0 | 4 | 1 | 2 | 0 | 1 | 3 | 0 | 3 | 2 | 2 | 1 | 2 | 1 | 1 | 5 | 4 | 0 | 3 | 3 | 1 | 2 | 2 | 1 | 0 | 0 |
02:00 - 02:59 | 0 | 0 | 1 | 1 | 0 | 2 | 1 | 4 | 0 | 1 | 0 | 3 | 2 | 3 | 3 | 2 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 2 | 0 | 0 | 4 | 1 | 2 | 0 | 0 |
03:00 - 03:59 | 1 | 2 | 0 | 0 | 2 | 0 | 3 | 0 | 2 | 0 | 0 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 4 | 1 | 1 | 0 |
04:00 - 04:59 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 1 | 0 |
05:00 - 05:59 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 3 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
06:00 - 06:59 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 1 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
07:00 - 07:59 | 3 | 1 | 3 | 2 | 1 | 1 | 0 | 0 | 0 | 3 | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 4 | 2 | 1 | 2 | 2 | 1 | 4 | 0 |
08:00 - 08:59 | 0 | 2 | 3 | 2 | 2 | 2 | 4 | 7 | 6 | 8 | 6 | 3 | 1 | 0 | 4 | 5 | 4 | 5 | 4 | 2 | 1 | 0 | 4 | 6 | 2 | 4 | 1 | 0 | 0 | 6 | 7 |
09:00 - 09:59 | 0 | 8 | 8 | 10 | 7 | 8 | 4 | 2 | 11 | 7 | 8 | 10 | 15 | 2 | 1 | 8 | 8 | 5 | 11 | 4 | 1 | 0 | 9 | 11 | 4 | 6 | 8 | 1 | 1 | 17 | 5 |
10:00 - 10:59 | 1 | 16 | 8 | 12 | 4 | 13 | 3 | 6 | 6 | 10 | 4 | 14 | 7 | 1 | 3 | 12 | 8 | 9 | 7 | 6 | 1 | 4 | 13 | 9 | 11 | 8 | 9 | 1 | 5 | 8 | 9 |
11:00 - 11:59 | 5 | 17 | 11 | 11 | 13 | 8 | 4 | 2 | 9 | 10 | 12 | 8 | 21 | 3 | 2 | 11 | 5 | 24 | 13 | 8 | 6 | 7 | 18 | 7 | 5 | 10 | 7 | 2 | 5 | 16 | 10 |
12:00 - 12:59 | 6 | 13 | 14 | 9 | 8 | 9 | 0 | 4 | 13 | 9 | 17 | 15 | 11 | 1 | 6 | 11 | 9 | 15 | 13 | 11 | 6 | 3 | 7 | 8 | 14 | 13 | 13 | 1 | 7 | 7 | 13 |
13:00 - 13:59 | 4 | 16 | 10 | 23 | 9 | 9 | 3 | 4 | 11 | 6 | 11 | 20 | 13 | 1 | 4 | 7 | 9 | 10 | 11 | 12 | 3 | 6 | 20 | 22 | 11 | 21 | 6 | 2 | 3 | 8 | 16 |
14:00 - 14:59 | 10 | 3 | 16 | 8 | 3 | 13 | 8 | 2 | 7 | 16 | 11 | 11 | 13 | 5 | 4 | 10 | 9 | 10 | 11 | 13 | 6 | 12 | 7 | 10 | 8 | 11 | 11 | 2 | 8 | 8 | 3 |
15:00 - 15:59 | 2 | 15 | 11 | 14 | 12 | 2 | 1 | 1 | 7 | 14 | 7 | 15 | 15 | 3 | 2 | 8 | 10 | 9 | 9 | 12 | 5 | 7 | 15 | 21 | 5 | 17 | 6 | 6 | 4 | 2 | 11 |
16:00 - 16:59 | 4 | 11 | 10 | 11 | 18 | 40 | 12 | 6 | 8 | 16 | 7 | 8 | 14 | 5 | 2 | 17 | 10 | 9 | 6 | 8 | 8 | 5 | 13 | 13 | 5 | 18 | 16 | 3 | 2 | 9 | 6 |
17:00 - 17:59 | 0 | 11 | 7 | 6 | 7 | 23 | 4 | 5 | 6 | 10 | 18 | 9 | 14 | 7 | 2 | 7 | 8 | 11 | 13 | 10 | 5 | 7 | 13 | 5 | 22 | 9 | 7 | 2 | 2 | 13 | 7 |
18:00 - 18:59 | 4 | 18 | 14 | 9 | 8 | 12 | 3 | 6 | 15 | 3 | 6 | 9 | 3 | 11 | 5 | 9 | 3 | 11 | 3 | 10 | 10 | 6 | 5 | 6 | 8 | 3 | 8 | 3 | 8 | 10 | 9 |
19:00 - 19:59 | 1 | 5 | 10 | 4 | 4 | 3 | 6 | 5 | 8 | 10 | 3 | 13 | 11 | 5 | 5 | 9 | 3 | 1 | 5 | 9 | 9 | 13 | 5 | 10 | 7 | 10 | 8 | 2 | 4 | 8 | 8 |
20:00 - 20:59 | 3 | 7 | 12 | 11 | 5 | 7 | 5 | 9 | 2 | 4 | 5 | 3 | 4 | 4 | 4 | 5 | 7 | 1 | 0 | 9 | 9 | 4 | 1 | 9 | 6 | 8 | 7 | 1 | 4 | 7 | 8 |
21:00 - 21:59 | 10 | 10 | 1 | 5 | 5 | 4 | 4 | 2 | 1 | 5 | 7 | 5 | 6 | 3 | 4 | 3 | 6 | 7 | 9 | 6 | 9 | 5 | 4 | 6 | 6 | 7 | 4 | 2 | 7 | 3 | 2 |
22:00 - 22:59 | 1 | 3 | 5 | 8 | 6 | 2 | 0 | 7 | 1 | 2 | 3 | 6 | 1 | 1 | 9 | 1 | 6 | 3 | 9 | 10 | 5 | 4 | 2 | 5 | 11 | 6 | 4 | 3 | 6 | 4 | 4 |
23:00 - 23:59 | 4 | 1 | 5 | 1 | 6 | 7 | 2 | 0 | 6 | 4 | 3 | 4 | 1 | 2 | 2 | 5 | 4 | 3 | 0 | 10 | 7 | 5 | 0 | 3 | 2 | 3 | 1 | 2 | 7 | 7 | 3 |
<colgroup><col width="96" span="2" style="width:72pt"> <col width="96" span="30" style="width:72pt"> </colgroup><tbody>
</tbody>