Re: SSMEDIAN

[Steven D'Aprano <steve pearwood info>]

Andreas Guelzow wrote:
> On Sat, 2011-04-09 at 11:34 +1000, Steven D'Aprano wrote:
[...]
> > * confirm that the formula above is that used by SSMEDIAN?
> >
> > * if not, what does SSMEDIAN actually do?
> >
> > * point me at a more authoritative source for the formula given?
>
>
> Since Gnumeric is open source, the easiest way of checking this is to
> check the source. 

Perhaps for C programmers, not for me :)


> Looking at the source an obvious typo is visible but that typo will onl
> affect the efficieny of the calculation for an even number of
> observations with the two central values not equal but it will not
> affect the result. 
>
> SSMEDIAN is supposed to calculate the median as described in "Using
> Basic Statistics in the Social Sciences" by Annabel Ness Evans.

Thank you, that is exactly the information I am after!




--
Steven