Forum Discussion

Lillioja's avatar
Lillioja
Copper Contributor
Sep 20, 2021
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.

6 Replies

  • mathetes's avatar
    mathetes
    Gold 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.

    • Lillioja's avatar
      Lillioja
      Copper Contributor

      mathetes 

      Raw data blue, running mean in red (moving average) period of 10 done by excel.

       
       

       

       

       

       

       

       

      • Lillioja's avatar
        Lillioja
        Copper Contributor
        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.

Resources