Use the free Moving Average Calculator below: your data never leaves your browser — all work happens on your device, and nothing is uploaded to any server.
Daily numbers jump around. Sales spike on Saturday and dip on Monday, temperatures swing with a single storm, and website visits surge when a post is shared. Looking at one day at a time makes the pattern hard to see, because the noise hides the trend. A moving average fixes that by replacing each value with the average of a small window of neighbours, so the jagged line smooths out and the underlying direction appears. The Moving Average Calculator builds that smoothed series from a pasted list.
This tool is built for people who want to see a trend without learning statistics software. You do not need a spreadsheet, a formula, or an upload. Everything happens in your browser, on your own device. Your numbers never leave the page, and nothing is sent to a server. That matters when the series holds business sales or private measurements you would rather not share.
To use it, paste a number series in time order, earliest first. The sample already in the box shows the shape. Then set the window size: how many values each average covers. A window of three is a gentle smooth that keeps most detail, while a window of seven suits daily data with a weekly rhythm, because each average covers a full week. Press Smooth series and the result lists the moving averages in order. Press Download CSV to save them as a file for a spreadsheet or a chart.
Choosing the window is the one judgment call, and it is worth trying more than one size. A window that is too small leaves most of the noise in place, so the smoothed line still jumps. A window that is too large flattens real changes, so a genuine turning point appears late or not at all. A good habit is to try three and seven, or three and five, and compare: the trend that survives both windows is the one to trust, while a bump that appears in only one window is probably noise.
A moving average has two honest limits that users should know. First, the smoothed series is shorter than the original, because a window cannot start before the data starts. With a window of three, a ten-value series gives eight averages, and the first and last days have no smoothed value in this simple version. Second, a moving average lags behind sudden changes. A sharp rise today only partly enters the average, and the smoothed line catches up over the next few windows. That lag is the price of smoothing, not a bug.
People use moving averages in many everyday jobs. Shop owners smooth daily sales to see whether trade is really rising or just had a good weekend. Runners smooth weekly mileage to check training load without reacting to one big week. Gardeners smooth daily temperatures to decide when to plant, and households smooth weekly spending to see whether the budget is drifting. In each case the question is the same: what is the direction once the daily noise is removed?
A common mistake is to paste the series out of order. A moving average depends on neighbours in time, so a shuffled list gives averages of unrelated values and a meaningless result. Always paste earliest first and check that the first average matches the average of your first window by hand. Another mistake is to read too much into the last smoothed value: because it lags, it describes the recent past better than today, and a decision that needs today’s figure should use the raw value too.
How to smooth a number series
- Paste your series in time order, earliest first.
- Set the window size, starting with three.
- Press Smooth series and read the averages.
- Try a second window size and compare the shapes.
- Press Download CSV to save the smoothed series.
Frequently asked questions
What window size should I use? Three for a gentle smooth, seven for daily data with a weekly rhythm. Try two sizes and compare.
Why is the smoothed series shorter? A window cannot start before the data starts, so the first values have no full window.
Does a moving average predict the future? No. It describes the recent past more clearly. It lags behind sudden changes.
Is my data uploaded? No. All averaging happens in your browser.
Paste a series you already follow, such as sales or temperatures, and smooth it twice with different windows. The direction that survives both is the trend worth acting on.
Pingback: Calcular Media Móvil Gratis - Suaviza tu Serie de Números con Ventanas