Identifying outliers through standard deviation

[Anonymous]

Hello,

I'm trying to find outliers in my data using standard deviation but I'm not sure how to go about doing this.

I have multiple standard deviations based on the category of salesman.  I want to find which salesmen are beyond the standard deviation of sales for that particular category, so to speak.

Can anyone help me with this?

Thank you in advance.

[swuehl]

Could you post some sample lines of records, best using a small sample QVW?

[swuehl · Accepted solution]

Maybe like attached?

[Anonymous]

Yes, this is what I was looking for.  I knew it had to be simple and that I was just over-thinking the problem.

Thank you so much swuehl!

[#5]

Hello, can someone explain how this is done? I can't import files in the personal edition.

Thanks!

[pamelabremer]

Hi Filippo,

In case you still needed this solution, I just stumbled upon it because it is useful to me too. The basic concept in the application is that each sales value is compared to the stddev

If  the absolute value of sales value minus the average of the sales values is greater than the stddev, then it is an outlier.