Moving Average Procedure

INTRO

It was asked on the Kodular forum if there was a function or procedure to "smooth" a data series. The easiest way to do this is to use a simple moving average. This creates a second dataset (from the original data) creating averages of subsets of the original data. Easy to do in a spreadsheet, but took (me) some head scratching to work out the blocks in order to make a procedure.

See here for more information about Moving Averages

BLOCKS

SCREEN

GRAPHS

You will see that the higher the number you use, the flatter and shorter the graph becomes....