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)

number	frequencies
0	1240
1	2395
2	5538
3	9837
4	14545
5	16061
6	21340
7	25770
8	22434
9	17497
10	12081

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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