Time Series in Excel

This tutorial provides a step-by-step example of how to plot the following time series in…

The following step-by-step example shows how to create a sales forecast in Excel. Step 1:…

In time series analysis, a moving average is simply the average value of a certain…

A cumulative average tells us the average of a series of values up to a…

The symmetric mean absolute percentage error (SMAPE) is used to measure the predictive accuracy of…

In statistics, the mean absolute error (MAE) is a way to measure the accuracy of…

The median absolute deviation is a way to measure the spread of values in a…

A naive forecast is one in which the forecast for a given period is simply equal…

Rolling correlations are correlations between two time series on a rolling window. One benefit of…

Autocorrelation measures the degree of similarity between a time series and a lagged version of itself…