Time Series in Excel

This tutorial provides a step-by-step example of how to plot the following time series in Excel: Let’s jump in! Step 1: Enter…

The following step-by-step example shows how to create a sales forecast in Excel. Step 1: Create the Data First, let’s create a…

In time series analysis, a moving average is simply the average value of a certain number of previous periods. An exponential moving…

A cumulative average tells us the average of a series of values up to a certain point. The following step-by-step example shows…

The symmetric mean absolute percentage error (SMAPE) is used to measure the predictive accuracy of models. It is calculated as: SMAPE =…

In statistics, the mean absolute error (MAE) is a way to measure the accuracy of a given model. It is calculated as:…

The median absolute deviation is a way to measure the spread of values in a dataset. The formula to calculate median absolute…

A naive forecast is one in which the forecast for a given period is simply equal to the value observed in the previous…

Rolling correlations are correlations between two time series on a rolling window. One benefit of this type of correlation is that you…

Autocorrelation measures the degree of similarity between a time series and a lagged version of itself over successive time intervals. It’s also sometimes…