how to compute for the median age of a population?

[nhoysanti]

single age Under 1	population 30,619
1	29,897
2	31,213
3	31,670
4	31,133
5	31,960
6	31,596
7	32,510
8	30,372
9	29,543
10	31,059
11	29,447
12	29,938
13	28,772
14	30,936
15	32,627
16	29,928
17	32,259
18	32,955
19	31,869
20	33,258
21	31,939
22	32,349
23	32,130
24	32,609
25	33,079
26	28,966
27	28,791
28	28,616
29	26,549
30	27,762
31	24,865
32	26,247
33	24,558
34	24,953
35	26,864
36	23,473
37	22,309
38	21,897
39	21,279
40	22,312
41	18,180
42	19,572
43	18,949
44	17,879
45	20,590
46	17,856
47	16,642
48	15,807
49	15,805
50	16,705
51	14,653
52	14,799
53	13,358
54	13,057
55	13,830
56	11,885
57	11,005
58	10,514
59	10,128
60	10,778
61	8,227
62	8,386
63	7,176
64	6,542
65	7,044
66	5,143
67	5,102
68	4,544
69	3,973
70	3,532
71	2,689
72	2,789
73	2,688
74	2,370
75	2,481
76	1,935
77	1,715
78	1,743
79	1,443
80 years and over	7,356

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

 

[footoo]

Are you sure you mean Median age ?
The population numbers are not necessary to work out the Median age : =MEDIAN(A2:A82)

If you mean the weighted average age : =ROUND(SUMPRODUCT(A2:A82,B2:B82)/SUM(B2:B82),0)

 

[Fazza]

welcome nhoysanti
what about using a helper column, such as in row zzz : =SUM($B$1:Bzzz)/SUM(B:B)
does that help you?
what answer are you expecting?
Fazza

 

[nhoysanti]

Age Bracket Under 1	Population 10,927
1 - 4	44,994
5 - 9	58,939
10 - 14	57,429
15 - 19	60,771
20 - 24	63,791
25 - 29	61,439
30 - 34	54,456
35 - 39	49,424
40 - 44	40,065
45 - 49	33,320
50 - 54	26,871
55 - 59	20,728
60 - 64	15,923
65 - 69	10,036
70 - 74	5,204
75 - 79	3,391
80 years and over	2,714

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

[h=2]how to compute for the median age of a population?[/h]