7 Replies Latest reply on Mar 12, 2018 2:12 PM by Johnny Hass

    How to identify the outliers in a distribution using standard deviation?

    Tony Fahd

      Hi,

      I am attaching a list of customers and their cost . each customer is categorized . also each customer has a type of connection . I want standard deviation for that set. i also like to identify the outliers based on their cost using 1 standard deviation form the mean. i need a field that says whether the customer is an outlier or no based on their cost.I like to add that field to the filter and be able to filter on whether each customer is an outlier or no.

       

      I tried so many ways, first i calculated the standard deviation for the set and then and i calculated the average for the set and can't find a way.

       

      any help is appreciated.