WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Dixon Test

 
   Home -> Office -> General Discussions RSS
Next:  excel horizontol scroll bar  
Author Message
Kevin Clark

External


Since: Mar 12, 2007
Posts: 1



(Msg. 1) Posted: Mon Mar 12, 2007 9:15 am
Post subject: Dixon Test
Archived from groups: microsoft>public>excel>misc (more info?)

I am looking for a way to automate the Dixon Test for determining outliers in
a data set in an Excel spreadsheet.
Back to top
Login to vote
Mike Middleton

External


Since: Sep 23, 2005
Posts: 338



(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?)

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.
Back to top
Login to vote
Jerry W. Lewis

External


Since: Mar 08, 2006
Posts: 250



(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).

http://www.jstatsoft.org/counter.php?id=158&url=v16/i03/v16i03.pdf&ct=1
gives a method for calculating p-values by Gaussian-type quadrature. The
abscissas and weights used there give about 3-place accuracy in the range of
Dixon's tables.

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.
Back to top
Login to vote
Jerry W. Lewis

External


Since: Mar 08, 2006
Posts: 250



(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.
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Help Forum Terms of Service |
  • Link to WUGNET |
  • IT Support