Calculation of a running mean

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use a spreadsheet to record test scores. There are 12 tests to be taken
over the year and I would like to calculate a running mean of the scores as
they are inputted. I have tried just calculating a mean but the spreadsheet
does not appear to be able to cope with calculating a mean from a formula
which refers to empty cells (those cells referring to the tests which have
yet to be taken).I am using Excel 2003 and I don't have the statistics
package available.

How do I calculate a running mean?
 
If data is in cells A1:A12, then =AVERAGE(A1:A12) will calculate average if
future test scores are left blank. Adding new data will update average.
 
Excellent. Thank you.

Toppers said:
If data is in cells A1:A12, then =AVERAGE(A1:A12) will calculate average if
future test scores are left blank. Adding new data will update average.
Click to expand...
 
Back
Top