Forum Discussion
Solved
Running mean.
I am using a running mean of 100 in noisy data. Can I fill in the mean for the first 99 obs with part means. I can do this one row at a time but can I get excel to do it automatically?
- Gets smoother still with a period of 100 but then there is a gap between 0 and 100. I can fill this in by hand but I thought there might be a short cut.
You've had quite a few views and no replies.
Could I suggest that you revise your question so that we, uh, can figure out what you "mean." "Mean" in this sense having to do with meaning.
It's not really clear--although it no doubt is in your mind--what you mean by your description of "running mean." So a fuller explanation of what you're doing and what you're wanting to achieve by doing that.....would help you get some help.
- Gets smoother still with a period of 100 but then there is a gap between 0 and 100. I can fill this in by hand but I thought there might be a short cut.
If the data is in A3:A1000, you can "work up" to a 100-unit moving average by entering the following formula in B3 and copying down the column:
=AVERAGE(INDEX(A:A, MAX(ROW(A$3),ROW()-99)):A3)
I use ROW(A$3) instead of simply 3 so that the number is adjust automagically if we move the data later.
- I need to learn some more commands to use in excel, but I see where you are going, thanks.
