Time Series in Excel
Excel
How to Calculate Weighted MAPE in Excel
One of the most common metrics used to measure the forecasting accuracy of a model is MAPE, which stands for mean absolute percentage error.
The formula to...
Excel
How to Find Weighted Moving Averages in Excel
A weighted moving average is a technique that can be used to smooth out time series data to reduce the “noise” in the data and more...
Excel
How to Perform Exponential Smoothing in Excel
Exponential smoothing is a technique for “smoothing” out time series data and is often used for short-term forecasting.
The basic idea is that time series data...
Excel
How to Calculate Mean Squared Error (MSE) in Excel
One of the most common metrics used to measure the forecast accuracy of a model is MSE, which stands for mean squared error. It is...
Excel
How to Calculate Mean Absolute Percentage Error (MAPE) in Excel
One of the most common metrics used to measure the forecasting accuracy of a model is MAPE, which stands for mean absolute percentage error.
The formula...
Excel
How to Calculate Root Mean Square Error (RMSE) in Excel
In statistics, regression analysis is a technique we use to understand the relationship between a predictor variable, x, and a response variable, y.
When we...
Excel
How to Easily Calculate the Mean Absolute Deviation in Excel
The mean absolute deviation is a way to measure the dispersion for a set of data values.
A low value for the mean absolute deviation is an...
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