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

    Excluding outliers from forecast generation

    Michael Feigin

      Hi,

       

      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.

       

      Thanks.

       

      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.