7 Replies Latest reply on Apr 6, 2018 12:13 AM by Zhouyi Zhang

    How do we calculate upper control limit and lower control limit for a moving average of sales

    Taukheer K

      Hi,

       

      I am trying to calculate moving average of daily sales along with the upper control limit and lower control limit. I have managed to get the moving average of daily sales, however I am not sure how to create upper control limit and lower control limit. My control value for n = 7.

       

      Could anyone assist, thanks.