Forecast Formula In Excel Based On Historical Data. The system then calculates a tolerance lane for the historical time series, based on the sigma factor. Once you've clicked the forecast sheet button, you'll see a nicely formatted graph that contains your data in blue along with predictive data in orange.
The forecast formula in excel to use is: Use the forecast sheet tool in excel 2016 or later to automatically create a visual forecast worksheet. =forecast(c43,c23:c42,d23:d42) we get the results as follow: