Forum Discussion
Lillioja
Sep 20, 2021Copper Contributor
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.
6 Replies
- mathetesGold Contributor
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.