AllanMiller
New member
- Joined
- Jul 20, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi, I have a table of age data from stats Canada and I can't figure out how to calculate the average and median age range based on data like this:
I want to be able to say, for example, the average age range is 45 to 49 years. Median would be good too. I just don't know how to write the formulas.
Your help is greatly appreciated.
AGE RANGE | COUNT |
0 to 4 years | 5460 |
5 to 9 years | 6320 |
10 to 14 years | 7610 |
15 to 19 years | 8190 |
20 to 24 years | 7350 |
25 to 29 years | 5720 |
30 to 34 years | 5885 |
35 to 39 years | 7690 |
40 to 44 years | 9230 |
45 to 49 years | 9420 |
50 to 54 years | 8285 |
55 to 59 years | 6480 |
60 to 64 years | 4335 |
65 to 69 years | 3090 |
70 to 74 years | 2525 |
75 to 79 years | 1740 |
80 to 84 years | 1020 |
85 years and over | 635 |
I want to be able to say, for example, the average age range is 45 to 49 years. Median would be good too. I just don't know how to write the formulas.
Your help is greatly appreciated.