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:
The running average of the last five numbers is: 12
If you add two more numbers, so that your column is now:
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.