__

Paramix Learning: Calculate Moving Average Of Last 5 Rows In Excel

Calculate Moving Average of last 5 Rows in Excel

By: Eddie Baki, 27.8.2015, 13:39

This videos shows you the steps needed to calculate not only the moving average of the last five numbers, but also the biggest value, smallest value and sum of these last 5 numbers.




A moving average is an average that changes every time you add or delete a number.

So if you have these numbers:
17
10
5
26
7
12

The running average of the last five numbers is: 12

If you add two more numbers, so that your column is now:
17
10
5
26
7
12
107
39

The running average is now: 38.2, because it dumped two older numbers and added the 107 and 39.

The steps used in the videos are:
1. Have Excel find the last occupied row of your data column using the function counta()
2. Use concatenation to produce the last cell of data
3. Using simple arithmetic, find out where your first cell of relevant data resides
4. Use the average() and indirect() functions to create your moving average

Please use the feedback link below for comments and suggestions.




E-Mail: mail@paramix.com

Telephone: (00 49) 93 41 98 99 037

Address:

Paramix e.K.
Muehlhof 6
97922 Lauda-Koenigshofen, Germany

Contact Form:

Your Name
Your E-Mail
Message