Need Help With Rosner Test

[PosseJohn]

I'm attempting to perform a ROSNER statistical test of my data.

Is there a WS function that might help me?

[MrShorty]

I am not familiar with the ROSNER test. You can check in the list of statistical functions to see if it is one of Excel's built in functions: https://support.office.com/en-us/art...__toc309306716

I found this article at NIST regarding the ESD test that credits Rosner. Perhaps it is the same test? http://itl.nist.gov/div898/handbook/...n3/eda35h3.htm

This gentlemen has a nice statistics for Excel website and add-in. In line with the NIST page, he claims to have some "outlier" functions, including one named ESD() and another named OUTLIERS() that are based on the ESD test. I have not used his add-in, so I know nothing about the utility or applicability of his resource pack. It might be worth looking into: http://www.real-statistics.com/real-...tal-functions/