Calculate Median from Frequency Table

[gracecyl]

Hello, does anyone know of a formula to calculate the median from this frequency table? (assuming the list goes on, way beyond row 10)

[TABLE="width: 188"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]number[/TD]
[TD]frequencies[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1240[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2395[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5538[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]9837[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]14545[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]16061[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]21340[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]25770[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]22434[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]17497[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]12081[/TD]
[/TR]
</tbody>[/TABLE]

 

[Benny236]

I may be missing something here but just =MEDIAN(B2:B400) or whatever length your table is should give you the median.

 

[gracecyl]

That is calculating median from a range. My question is asking about calculating median from a frequency table, NOT a string.

 

[AhoyNC]

I think this will do what you want.
First calculate the cumulative frequency.
Then the position of the median will be (n+1)/2 or 74369.5 in your example.
You could then use the LOOKUP function to find the number or 6 in your example.

Excel Workbook
	A	B	C	D	E
1	number	frequencies	CF		Position of Median = (n+1)/2
2	0	1,240	1,240		74369.5
3	1	2,395	3,635		Median
4	2	5,538	9,173		6
5	3	9,837	19,010
6	4	14,545	33,555
7	5	16,061	49,616
8	6	21,340	70,956
9	7	25,770	96,726
10	8	22,434	119,160
11	9	17,497	136,657
12	10	12,081	148,738
Sheet