Moving Average Forecast Calculator

Instructions: You can use this Moving Average Forecast Calculator for a given times series data set, by providing a set of data and the number of periods to compute the average for (For example, for a 3-month Moving Averages, the number of periods to use is 3). Also, you can indicate if the data periods are months or not, and you optionally can write your own custom names for the time periods in the form below:

Data (space or comma separated)
Number of Periods to Average
Monthly Time Periods?
Starting Month:
Custom Period Labels (optional)

Moving Average Calculator

More about the Moving Average Forecasts so you can get a better understanding of the outcome that will be provided by this solver. The idea behind Moving Averages for making forecasts consists of estimating the data value of certain period based on the average values for the dataset in the previous month. For example, if we are computing 3-month Moving Averages (MA), we would use the following formula to estimate the data value during period \(n\)

\[ \text{Forecast during period n} = \hat Y_n = \displaystyle \frac{Y_{n-3} + Y_{n-2} + Y_{n-1}}{3}\]

The Moving Averages (MA) method of forecasting is one of the easiest and most common methods to make forecasts based on a times series data set. Other common methods are the naive forecast method, the weighted moving averages, the exponential smoothing forecast method, and the linear trend forecasting method, just to mention a few.

In case you have any suggestion, or if you would like to report a broken solver/calculator, please do not hesitate to contact us.

log in

reset password

Back to
log in