how to compute for the median age of a population?

[nhoysanti]

[TABLE="width: 446"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]single age

Under 1[/TD]
[TD] population

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

 

[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]

[TABLE="width: 442"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Age Bracket
Under 1[/TD]
[TD] Population 10,927[/TD]
[/TR]
[TR]
[TD]1 - 4[/TD]
[TD] 44,994[/TD]
[/TR]
[TR]
[TD]5 - 9[/TD]
[TD] 58,939[/TD]
[/TR]
[TR]
[TD]10 - 14[/TD]
[TD] 57,429[/TD]
[/TR]
[TR]
[TD]15 - 19[/TD]
[TD] 60,771[/TD]
[/TR]
[TR]
[TD]20 - 24[/TD]
[TD] 63,791[/TD]
[/TR]
[TR]
[TD]25 - 29[/TD]
[TD] 61,439[/TD]
[/TR]
[TR]
[TD]30 - 34[/TD]
[TD] 54,456[/TD]
[/TR]
[TR]
[TD]35 - 39[/TD]
[TD] 49,424[/TD]
[/TR]
[TR]
[TD]40 - 44[/TD]
[TD] 40,065[/TD]
[/TR]
[TR]
[TD]45 - 49[/TD]
[TD] 33,320[/TD]
[/TR]
[TR]
[TD]50 - 54[/TD]
[TD] 26,871[/TD]
[/TR]
[TR]
[TD]55 - 59[/TD]
[TD] 20,728[/TD]
[/TR]
[TR]
[TD]60 - 64[/TD]
[TD] 15,923[/TD]
[/TR]
[TR]
[TD]65 - 69[/TD]
[TD] 10,036[/TD]
[/TR]
[TR]
[TD]70 - 74[/TD]
[TD] 5,204[/TD]
[/TR]
[TR]
[TD]75 - 79[/TD]
[TD] 3,391[/TD]
[/TR]
[TR]
[TD]80 years and over[/TD]
[TD] 2,714[/TD]
[/TR]
</tbody>[/TABLE]
[h=2]how to compute for the median age of a population?[/h]