2 Replies Latest reply on Oct 9, 2017 11:52 AM by Michael Feigin

    Excluding outliers from forecast generation

    Michael Feigin



      I am trying to generate a forecast based on about three months worth of data.

      One data point is a clear outlier and I would like it to be excluded from the forecast.

      So, a couple of questions...

      1. How can I exclude a single data point from the forecast calculation?

      2. May I automatically exclude all values that are 3 standard deviations or more from the average when generating a forecast?


      I am including my dataset.




      P.S. in This specific case the outlier is the very first data point, and I can, in principle, just exclude it, however, my real data may have an occasional outlier in the middle as well.