# how to compute for the median age of a population?

#### nhoysanti

##### New Member
 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>

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### footoo

##### Well-known Member
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

##### MrExcel MVP
welcome nhoysanti
what about using a helper column, such as in row zzz : =SUM(\$B\$1:Bzzz)/SUM(B:B)
Fazza

#### nhoysanti

##### New Member
 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]

1,129,791
Messages
5,638,340
Members
417,021
Latest member
moon miner

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back