Tag Archives: Moving Average

Daily Download 26: Moving averages and prime numbers

Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Moving Average Function

The previous post presented a simple moving average user defined function (UDF).  This has been extended to provide additional functionality: A weighted average may be returned; either a linear weight with a specified step value, or a using any specified weighting … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Moving averages and User Defined Array Functions

I have recently needed to work with moving averages on a large-ish data set (about 10,000 rows x 10 columns), and for reasons that I will describe in the next post, decided that a User Defined Function (UDF) would be … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 8 Comments