Re: Mathematicians !! Percentile/Quartile function
- Posted by Pete Stoner <stoner.pete at gmail.com> Sep 07, 2005
- 576 views
Pete Lomax wrote: > > On Wed, 07 Sep 2005 09:45:41 -0700, Pete Stoner > <guest at RapidEuphoria.com> wrote: > > >i.e. for values of {2, 6, 7, 10, 14, 15, 16} the quartiles are 6.5, 10 and > >14.5 > >but for a range of {2, 6, 7, 10, 14, 15} the correct quartiles seem to be > >6.25, 8.5 & 13 > FWIW, (and strictly from observation only!) the first is (or might be) > (6+7)/2, 10, (14+15)/2, while ths second is (or might be) > (2+6+7+10)/2, (7+10)/2, (10+14+15)/2 > > As I don't have either Excel or 123 to hand, I can't experiment more, > but I wonder what happens with sets of longer numbers. > I just tried it with a larger set.. {2,2,2,3,6,6,8,8,10,12,12,14,16,19,22,25,28,28,32,33} results are Lucius - 3, 12, 22 Juergen and I got 6, 12, 23.5 123 and Excel give 6, 12, 22.75 Regards Pete