On Tue, Feb 23, 2010 at 8:28 AM, Henry Baker <hbaker1@pipeline.com> wrote:
I was hacking a spreadsheet today & wanted to compute a moving average. I wasn't terribly particular about which moving average, but didn't find any moving averages in the list of functions that the spreadsheet program (OpenOffice Calc) offered.
You just average over a window in one cell and then "fill down". The indices get incremented automatically. http://people.usd.edu/~bwjames/tut/excel/26.html For example, say you had 100 data in column A and wanted a ten-cell window. In cell B10, you'd put = SUM(A1:A10)/10 Then you'd select the range from B10 to B100 and "fill down". The result is that in cell B11 you'd have = SUM(A2:A11)/10 and so on down to B100, which is just what you want. -- Mike Stay - metaweta@gmail.com http://math.ucr.edu/~mike http://reperiendi.wordpress.com