Dependency Ratios & Service Demand: Young and Old Ratios, School-Age Counts and Classes Needed
This lesson is part of the course
In this lesson
You read a fictional central projection for 2026, 2036 and 2046, calculate young and old-age dependency ratios with SUMIFS and turn the school-age population into the classes the district will need.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Age-Band Profile: Counts, Shares, the Median Band and the 65+ Share Locked
- Crude Rates per 1,000: Births, Deaths, Natural Increase and Net Migration Locked
- Components of Change: the Balancing Equation, Residuals and Where Growth Comes From Locked
- Cohort Projection, Step 1: Moving Every Band Forward Five Years with Survival Ratios Locked
- Cohort Projection, Step 2: Births from Fictional Rates and Net Migration by Band Locked
- Ten- and Twenty-Year Projections: Repeating the Step, Following a Cohort, Measuring Ageing Locked
- Dependency Ratios & Service Demand: Young and Old Ratios, School-Age Counts and Classes Needed Locked
- Scenario Dashboard: Low, Central and High Migration Compared in a Table and a Chart Locked