example.png
Hi guys,
I have one column which represents weeks and one which represents sales of products in one week.
My task is to generate prognosis for next free months depending on the previous data. I have generated weeks and I do not know if there is any tool in excel that would help to generate prognosis of sales for these weeks.
I have added a screenshot with a graph. Horizontal axis is time and vertical sales. It can be seen that there is a seasonal trend.
Thank you.
Office 365 has few method of forecasting.
1. Forecast.ETS series of functions.
Have a read of link. It also has good sample data to play with.
https://www.ablebits.com/office-addi...mula-examples/
2. In Data Ribbon you should have Forecast Sheet button.
This will allow you to set some parameters and play with options (automatic seasonality detection etc).
0.JPG
There are other methods, but these should get you started.
However, do note that this is only one method of forecasting, and you should carefully validate forecast vs actual variance etc. And ensure that this model fits your need.
If you need more direct help. I'd recommend uploading sample workbook with desensitized data set.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks