
1. Re: Calculating outliers using standard deviation
Shinichiro Murakami Apr 26, 2018 8:22 AM (in response to james.evans.10)HI James
Could you please attach sample data as packaged workbook(**.twbx).
Thanks,
Shin

2. Re: Calculating outliers using standard deviation
Jim Dehner Apr 26, 2018 8:30 AM (in response to james.evans.10)Hi James  total concentration looks like an LOD not a table calculation  it is not aggregated so your conditional statement is looking for an aggregation
Try this
IF SUM( [Total Concentration ] ) > 3*[Standard Deviation ] THEN 'Outlier'
ELSE 'NonOutlier'
END
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

3. Re: Calculating outliers using standard deviation
Jim Dehner Apr 26, 2018 8:37 AM (in response to james.evans.10)sorry that aggregation should have been min() and not sum
IF MIN( [Total Concentration ] ) > 3*[Standard Deviation ] THEN 'Outlier'
ELSE 'NonOutlier'
END
Jim

4. Re: Calculating outliers using standard deviation
james.evans.10 Apr 26, 2018 8:50 AM (in response to Shinichiro Murakami)I've attached a sample workbook

5. Re: Calculating outliers using standard deviation
james.evans.10 Apr 26, 2018 8:50 AM (in response to Jim Dehner)Hi Jim, adding Min() does make the calculation valid but does not achieve my objective unfortunately. I have attached a sample workbook to my post. Thanks!

6. Re: Calculating outliers using standard deviation
Jim Dehner Apr 26, 2018 9:05 AM (in response to james.evans.10)see the attached
I changed the std dev calculation to
that makes the outlier calculation correct
and will return this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Outlier Calculation_v10.2.twbx 315.2 KB


7. Re: Calculating outliers using standard deviation
james.evans.10 Apr 26, 2018 9:11 AM (in response to Jim Dehner)Jim,
That's what I was missing, thank you!!

8. Re: Calculating outliers using standard deviation
Jim Dehner Apr 26, 2018 9:11 AM (in response to james.evans.10)Glad to help out
Jim