### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Downloads by category
- The angle between two vectors, Python version
- Retrieving unique values from a range or array ...
- Plotting Mandelbrot
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- 3DFrame - 3D Frame analysis for Excel
- Writing Arrays to the worksheet - VBA function

### Recent Comments

# 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

## 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

## 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 Array Function, Excel, Moving Average, UDF, VBA
8 Comments