Moving average, Centered moving average, Ratio to moving average ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

Moving average, Centered moving average, Ratio to moving average ...

       Time   Period Quarter Sales   1 3 125.3   2 4 155   3 1 117   4 2 88.5   5 3 103.4   6 4 168.7   7 1 164.9   8 2 100.9   9 3 108.1   10 4 198.9   11 1 151.7   12 2 121.4    

    • 7 years ago
    We are calculating a 4-period moving average here. So, the first entry ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      ThefirstentryintheMovingAveragecolumnwillbetheaverageofthesalesfigures.xlsx