*From*: Steven D'Aprano <steve pearwood info>*To*: gnumeric-list gnome org*Subject*: SSMEDIAN*Date*: Sat, 09 Apr 2011 11:34:07 +1000

Hello,

I have read the description of the function: "median for grouped data as commonly determined in the social sciences" http://projects.gnome.org/gnumeric/doc/gnumeric-SSMEDIAN.shtml

Likewise the data point 8 means 7.5 through 8.5. So we have grouped data: Group Frequency 6.5 - 7.5 1 7.5 - 8.5 2 If I apply the formula for grouped median found here: http://www.duncanwil.co.uk/average4.html median = L + i*(n/2 - CF)/f where: L = the lower limit of the class containing the median i = the width of the class containing the median n = the total number of frequencies

f = the frequency of the median class I get: median = 7.5 + 1*(3/2 - 1)/2 = 7.75

* 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? Thank you in advance! -- Steven

**Follow-Ups**:**Re: SSMEDIAN***From:*Andreas Guelzow

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]