2 Replies Latest reply on Jun 13, 2018 3:13 PM by Megha Bhatnagar

    Replacing outliers with rolling average

    Megha Bhatnagar

      Hi,

      I have a graph with weekly data and the data for week 2 and 3 is inflated. We want to replace the data for week 2 and 3 with rolling average from previous weeks.

      I cannot manipulate the data in the back end because they would like to keep the data set as it is.

       

      I am attaching a mock workbook. I need to replace the data for the orange spike (week 54 and 55 ) with the rolling average of previous weeks. Any ideas on how to accomplish that?