...Excel add-in for quick data analysis  

 

 

   
Fil "box plot ranges" Lancé par Paul Edmunds le 29/03/2008 22:30
Cette page : 1 de 1 Aller à la page : 1
box plot ranges
Envoyé par : Paul Edmunds  le 29/03/2008 22:30
Hi Vandan,
I have been making box plots and using the data labels of 25%, 50%, and 75%. I am wondering what percentage of the data is typically demonstrated above the minimum and maximum whiskers? That is, in what range do the outliers belong to?
Thank you!
Paul
Re: box plot ranges
Envoyé par : Vandan  le 11/12/2006 9:17
Paul:

VTools uses following to calculate whiskers:

* Upper Whisker: = Min (Max(data), 75% + (1.5 * IQR))
* Lower Whisker: = Max (Min(data), 25% - (1.5 * IQR))

IQR := InterQuartile Range (75% - 25%)

i.e. anything higher than 75th percentile + 1.5 IQR is an outlier.

For a well behaved data set, there should be no outliers!
Re: box plot ranges
Envoyé par : Paul Edmunds  le 13/02/2007 16:32
Hi Vandan - hope you are off to a great new year 2007!

Following up on some help you offered me in December, am I correct in saying that values below the minimum whisker would be: the 25th percetile - 1.5 IQR? I am trying to document how outliers above and below the max and min are calculated.

Thank you!
Paul



VTools uses following to calculate whiskers:

* Upper Whisker: = Min (Max(data), 75% + (1.5 * IQR))
* Lower Whisker: = Max (Min(data), 25% - (1.5 * IQR))

IQR := InterQuartile Range (75% - 25%)

i.e. anything higher than 75th percentile + 1.5 IQR is an outlier.

For a well behaved data set, there should be no outliers!
Re: box plot ranges
Envoyé par : Vandan  le 14/02/2007 18:55
That is correct.
Re: box plot ranges
Envoyé par : Paul Edmunds  le 16/02/2007 1:28
Thank you, Vandan!
Paul
Re: box plot ranges
Envoyé par : test  le 17/04/2008 12:37
test
Cette page : 1 de 1 Aller à la page : 1
Forum powered by FreeForum

Sep 21, 2006

VTools version 3.3.3 is released. Download your copy from the download page.

Support VTools by purchasing your copy today.

Purchase VTools

 

       

home | download | user guide | user forum | links | e-mail

Last updated: October 23, 2006 11:37 AM