Question

Table 1.3  Hillsboro County Age Profile by Sex
				Ages
City/Town	Total	Under 5	5−14	15−24	25−44	45−64	65−74	75
Jasper	51,230	3,942	7,647	7,533	15,726	11,487	3,083	1,812
Middleboro	48,502	3,203	7,060	6,725	13,904	10,661	3,522	3,427
Statesville	14,780	1,022	2,151	1,920	4,516	3,282	903	986
Harris City	12,835	805	1,868	1,780	3,629	2,850	848	1,055
Mifflenville	11,253	712	1,448	1,259	3,655	2,499	743	937
Carterville	2,198	102	320	305	655	488	156	172
Minortown	2,005	109	292	278	497	445	163	221
Boalsburg	1,964	114	286	272	586	436	143	128
Total	144,768	10,009	21,072	20,072	43,168	32,148	9,561	8,738

To what degree does the age profile of Hillsboro County resemble the overall age profile demographic of the United States? Which towns in the county are the oldest and the youngest? (The overall age profile demographic in the United States is 37.9 years.

Answer 1

Finding the mean age will give the overall age profile demographic:

M*F= (Mid age) * (Frequency)

Midpoint (M)	Jasper (M*F)	Middleboro (M*F)	Statesville (M*F)	HarrisCity (M*F)	Mifflenvile (M*F)	Carteville (M*F)	Minortown (M*F)	Boalsburg (M*F)
2.5	9855	8007.5	2555	2012.5	1780	255	272.5	285
9.5	72646.5	67070	20434.5	17746	13756	3040	2774	2717
19.5	146893.5	131664	37440	34700	24550.5	5947.5	5421	5304
34.5	542547	479688	155802	125200.5	126097.5	22597.5	17146.5	20217
54.5	626041.5	581024.5	178869	155325	136195.5	26596	24252.5	23762
69.5	214268.5	244779	62758.5	58936	51638.5	10842	11328.5	9938.5
75	135900	257025	73950	79125	70725	12900	16575	9600
Total	1748152	1769258	531809	473045	424743	82178	77770	71823.5

Mean age = total / total frequency(for each city)

Mean age (Jasper) = 1748153/51230 = 34.12

Mean age (Middleboro) = 1769258/48502 = 36.48

Mean age (Statesville) = 531809/14780 = 35.98

Mean age (Harris City) = 473045/12835 = 36.80

Mean age (Mifflenville) = 424743/11253 = 37.75

Mean age (Carterville) = 82178/2198 = 37.39

Mean age (Minortown) = 77770/2005 = 38.7

Mean age (Boalsburg) = 71823.5/1964 = 36.57

Overall mean = 35.77

Thus age profile of Hillsboro County is little less than the overall age profile demographic of the United States which is 37.9

According to mean age of different towns Jasper is youngest town while Minortown is older as it has highest mean age