A calculation used to analyze data points by creating a series of averages of different subsets of the full data set.
Probeer het met AIA moving average smooths out short-term fluctuations and highlights longer-term trends or cycles in a time series. It is commonly used in Excel to filter out noise from volatile data, such as stock prices or monthly sales figures, by averaging a fixed number of preceding periods.
=AVERAGE(OFFSET(A2, 0, 0, -7, 1))If you have daily sales for a month, a 7-day moving average helps you see the weekly trend by averaging the current day and the previous six days.
A simple average summarizes the entire dataset into one number, whereas a moving average tracks how the average changes over time, revealing trends.