Time Series in Excel
Excel
How to Calculate a Cumulative Average in Excel
A cumulative average tells us the average of a series of values up to a certain point.
The following step-by-step example shows how to calculate...
Excel
How to Calculate SMAPE in Excel (With Examples)
The symmetric mean absolute percentage error (SMAPE) is used to measure the predictive accuracy of models. It is calculated as:
SMAPE = (1/n) * Σ(|forecast...
Excel
How to Calculate Mean Absolute Error in Excel (Step-by-Step)
In statistics, the mean absolute error (MAE) is a way to measure the accuracy of a given model. It is calculated as:
MAE = (1/n)...
Excel
How to Calculate Median Absolute Deviation in Excel
The median absolute deviation is a way to measure the spread of values in a dataset.
The formula to calculate median absolute deviation, often abbreviated...
Excel
Naive Forecasting in Excel: Step-by-Step Example
A naive forecast is one in which the forecast for a given period is simply equal to the value observed in the previous period.
For example,...
Excel
How to Calculate Rolling Correlation in Excel
Rolling correlations are correlations between two time series on a rolling window. One benefit of this type of correlation is that you can visualize...
Excel
How to Calculate Autocorrelation in Excel
Autocorrelation measures the degree of similarity between a time series and a lagged version of itself over successive time intervals.
It’s also sometimes referred to as...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read