In previous posts we looked a few simple ways to create forecasts in Excel, first using Time Series Decomposition, and also regression against business drivers.
Have you ever wondered how Excel calculates that nice trend line in your not so perfect data? I’m guessing not and that you take it for granted, and hand in reports without actually knowing the statistics and...
In my earlier posts on forecasting with Time Series Decomposition (see Forecasting: Further Time Series Decomposition in Excel) we looked at producing a forecast based on historical behaviour of the data. The...
In the previous three parts of this blog series we have developed a forecast of file storage size and implemented some parameters to allow the end user to adjust the forecast (such as adding additional growth to...
Full series: capacity modelling guide
In Basic Time Series Decomposition in Excel I gave a brief demonstration of some simple forecasting methods, showing how to include not only growth but seasonality. By the end of that post we had a forecast like...
