Calculating the median from a frequency table?

[uffe]

Hello!

I would like to calculate the median for a distribution involving frequencies for each value. Lets say my students write a very small exam which can render up to 10 points, and that the results are (picture below):

I would like to create an internal array like {3,3,4,4,4,5,5,5,6,8} from which to calculate the median. How on earth is this done?

Thanks!
Uffe

[scottiex]

maybe

Please Login or Register  to view this content.

[uffe]

This formula will produce the mean, however I want to calculate the median (middle value if sorted)!

[scottiex]

oh OK. I think this works.

Please Login or Register  to view this content.

[shg]

Another way:

	A	B	C	D	E	F	G	H	I	J	K	L	M
2	Points	0	1	2	3	4	5	6	7	8	9	10
3	Freq				2	3	3	1		1
4	Median	4.5											B4: {=MEDIAN(IF(ROW(INDEX(B:B, 1):INDEX(B:B, MAX(B3:L3))) <= B3:L3, B2:L2))}

[uffe]

Thanks guys! I'll translate these to my original problem and see to that it works the way I want it!

Hats off!