6 Replies Latest reply on Oct 9, 2015 8:27 AM by Mike O'Connor

    best way to remove outliers - trendline / reference line / any other idea

    Rajdeep Panchal

      I am trying to find outliers for set of data over period of 2 years - per day per location combination. I  tried to create scatter plot but it is not giving me an exact idea of removing outliers. I am pasting a model i tried to recreate using super store data set, need to know, what is best way to remove outliers? Here is what i could come up with

       

      plot scatter plot and remove outliers by eyeball - seems to be not so reliable and non- scientific model

      plot scatter plot and put standard deviation, remove data outside of standard deviation

       

      I want to run this by forum and see if someone has any idea or at least someone can tell if i am thinking on right path? Or should i go out of tableau and use excel to remove outliers?