Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forecasting
Hi!
Let's say I would like to make the forecast based on the averages of all previous known data. For example: I have a day increment in column A and call volume in B. Call volume oscilates depending on the day of the week but the oscilation is constant and it repeats it self week after week. So what I want is to forecast the call volume for the starting week, day by day, by using previous data for the same day in the week. Is this senseless? Perhaps there is a better way to forecast upon single parameter? BR Kruno, Croatia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forecasting | Excel Discussion (Misc queries) | |||
Forecasting using arrays | Excel Worksheet Functions | |||
Forecasting weekday occupancy between two years | Excel Worksheet Functions | |||
Forecasting By Date | Excel Discussion (Misc queries) | |||
Excel Solver background in forecasting modeling | Excel Worksheet Functions |