#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 837
Default Dixon Test

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/fundsta...ts_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" <Kevin 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate mean of test scores from rows of test answers RiotLoadTime Excel Discussion (Misc queries) 1 July 26th 06 05:14 PM
test Splint Excel Discussion (Misc queries) 0 April 11th 06 08:25 PM
wrn.test Ellen634 Excel Discussion (Misc queries) 1 April 6th 06 10:00 PM
Test Ford New Users to Excel 1 October 27th 05 09:24 PM
test..where are my messages..test HT New Users to Excel 0 January 23rd 05 06:23 PM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"