(Msg. 2) Posted: Mon Mar 12, 2007 10:31 am
Post subject: Re: Dixon Test [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
it's a simple matter to compute the test statistic Q using Excel's ABS, MIN,
MAX, and LARGE or SMALL worksheet functions.
But I don't have access to a source that describes how to compute the
sampling distribution of Q for determining a p-value or conducting a
hypothesis test.
(Msg. 3) Posted: Mon Mar 12, 2007 1:01 pm
Post subject: Re: Dixon Test [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks for a reference that I hadn't seen before. The algorithm for
selecting among Dixon-type statistics based on sample size is endorsed by
ASTM (E-178).
Note that the tables in your reference have not been previously published,
and extend Dixon's tables to smaller p-values and larger n than Dixon
published. The larger n may not be useful in practice since the range
becomes a very inefficient estimator of variance for large n. However the
accuracy of these tables is not bad. The author says they are based on Monte
Carlo simulation with 10^6 reps per value. Around the turn of the century I
calculated (by adaptive quadrature) unpublished Dixon tables that I believe
to be accurate to 6 decimal places over an even broader range of p-values for
n<=100. Comparing your reference to my tables, your reference seems to have
an error of no more than 0.003 in its tabled values, which is better than
Dixon's original tables.
Jerry
"Mike Middleton" wrote:
> Kevin -
>
> Referring to
>
> http://www.statistics4u.info/fundstat_eng/cc_outlier_tests_dixon.html# >
> it's a simple matter to compute the test statistic Q using Excel's ABS, MIN,
> MAX, and LARGE or SMALL worksheet functions.
>
> But I don't have access to a source that describes how to compute the
> sampling distribution of Q for determining a p-value or conducting a
> hypothesis test.
>
> - Mike
> http://www.mikemiddleton.com >
> "Kevin Clark" wrote in message
> > >I am looking for a way to automate the Dixon Test for determining outliers
> >in
> > a data set in an Excel spreadsheet.
(Msg. 4) Posted: Mon Mar 12, 2007 1:12 pm
Post subject: Re: Dixon Test [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Note also, that these p-values are for 1-sided outlier tests, whereas outlier
testing is inherently 2-sided, unless there is some objective basis for
believing that outliers can only occur in one direction. Thus for most
cases, these p-values should be doubled, as in Rorabacher's tables
(Analytical Chemistry 63[2]:139-146, 1991) and USP <111>.
Jerry
"Mike Middleton" wrote:
> Kevin -
>
> Referring to
>
> http://www.statistics4u.info/fundstat_eng/cc_outlier_tests_dixon.html# >
> it's a simple matter to compute the test statistic Q using Excel's ABS, MIN,
> MAX, and LARGE or SMALL worksheet functions.
>
> But I don't have access to a source that describes how to compute the
> sampling distribution of Q for determining a p-value or conducting a
> hypothesis test.
>
> - Mike
> http://www.mikemiddleton.com >
> "Kevin Clark" wrote in message
> > >I am looking for a way to automate the Dixon Test for determining outliers
> >in
> > a data set in an Excel spreadsheet.
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum