Sales Forecasting in Excel
Budget: £20 – £250 GBP
The data set contains sales values for two stores. For this analysis it is required to :
- calculate probability that worst performing store will achieve at least 50% of sales of best performing store
(mean, variance, probability)
- apply clustering (months similar to other months)
- find trends, remove seasonality and present it in line graphs
- Arima model to forecast
- calculate probability that worst performing store will achieve at least 50% of sales of best performing store
(mean, variance, probability)
- apply clustering (months similar to other months)
- find trends, remove seasonality and present it in line graphs
- Arima model to forecast