3 Replies Latest reply on Jul 10, 2016 8:14 PM by Patrick Myles

    Percent Diff with a moving average

    Patrick Myles

      Hi all - I have a problem I can't solve:

       

      I have a series of values which I have created a percentage difference (from previous value) on.  It produces a line which is a bit erratic so I want to put a 3 month moving average on it.  I can't seem to get an equation for it.  I've attached the workbook with the values expressed as percentage diff (from previous value).  Anyone know how i can put a 3 point moving average to the values so as to smooth the line?

       

      Regards

      Patrick