Statistical Analysis Dashboard

Comparative Socioeconomic Analysis

Comprehensive statistical analysis of Magdalena, Liliw, and Majayjay covering population, gender, age groups, households, social welfare programs, ANOVA, and Pearson correlation.

Year: 2015 2020 2024 Data for 2024
Descriptive Analysis Population Growth Gender Trend Age Group Household vs Population Program Beneficiaries ANOVA Analysis Correlation Analysis Key Insights Recommendations

1. Descriptive Analysis

96,679
Total Population (2024)
Highest: Liliw
21,738
Total Households
Highest: Liliw
11,735
Total Beneficiaries
Highest: Liliw
Population, Households & Beneficiaries per Municipality

Grouped bar chart 2024

Key Differences
Municipality Population Benef. %
Liliw 39,976 14.3%
Magdalena 28,200 10.1%
Majayjay 28,503 11.1%

Liliw leads in population. Liliw has the most welfare beneficiaries. Beneficiary rates range from 10.1% to 14.3%.

2. Population Growth Analysis

Population per Year per Municipality

Line chart all recorded years

Growth Rates
Liliw +4.59%
Avg. yearly growth
Magdalena +5.74%
Avg. yearly growth
Majayjay +1.28%
Avg. yearly growth

Magdalena shows the fastest average population growth among the three municipalities.

Key Finding

Magdalena shows the highest population growth rate at 5.74%, indicating rapid demographic expansion compared to nearby municipalities.

Explanation of Growth Trend
Young Population Structure
Higher birth rates due to lower median age contribute to sustained natural population increase.
Sustained Growth Trend
Continuous increase based on census data reflects a long-term upward demographic trajectory.
Resource Availability & Settlement Expansion
Access to water and land in the Santa Cruz watershed supports population growth, leading to expansion of settlements and built-up areas.
Increasing Human Activities & Environmental Interaction
Rising population leads to increased land use, water consumption, and environmental changes, reflecting strong interaction between people and natural resources.
Supporting Evidence
1
PhilAtlas (2020)
Magdalena, Laguna Population Data
View Source
2
Magpantay & Sanchez (2023)
JESAM Environmental & Socio-demographic Study
View Source
3
Sandoval et al. (2023)
Water Quality Assessment Santa Cruz River, Laguna
View Source
Conclusion

The rapid population increase in Magdalena is driven by a combination of demographic factors and environmental-resource dynamics. The availability of water and land supports continuous settlement expansion, while increasing human activities further accelerate growth.

However, this growth also places pressure on natural resources, particularly water systems and land use. As population increases, environmental impacts such as changes in land cover and water quality become more evident. Therefore, sustainable resource management is essential to balance population growth with environmental protection.

3. Gender Trend Analysis

Male vs Female Trend Over Years

Combined across all municipalities

Male vs Female per Municipality

2024

Total Male: 49,069  |  Total Female: 47,542
Male-dominant across municipalities.
Key Finding

Male population is higher in 2024: 49,069 males vs 47,542 females (difference: 1,527).

Explanation of Gender Pattern
Migration Selectivity
As discussed in migration literature, mobility can be sex-selective, especially for employment-related movement. This can produce male-heavy local counts in specific years.
Observed Local Structure
In this dataset, male counts are higher across Liliw, Magdalena, Majayjay. This supports a consistent pattern rather than a one-time anomaly.
Program Planning Implication
Current composition is 50.8% male and 49.2% female. MSWDO planning should remain gender-responsive and validated yearly using official PSA updates.
Supporting Evidence
1
PSA (2018 National Migration Survey)
Migration Experiences of Filipinos
View Source
2
PSA Infographic (Single Population)
Sex and Civil Status Profile Infographic
View Source
Conclusion

The selected-year analysis shows a male-leading population profile. This can be explained by local demographic composition and migration behavior documented in national-level RRL.

For policy use, maintain gender-responsive targeting while validating this gap every year using updated official statistics.

4. Age Group Analysis

Age Groups per Municipality (Stacked)

Youth (0-19), Working Age (20-59), Senior (60+) 2024

Dependency Ratios

(Youth + Senior) / Working Age × 100

Liliw 56.8%
Magdalena 58.2%
Majayjay 55.8%

Dominant age group: Working Age (20–59).
Aging population prioritize elder care and pension services.

Key Finding

Age-group records for 2024 show a consistent dominance of Working Age (20-59) across municipalities, with totals at 61,199 (63.7%), higher than Youth (28,635) and Senior (6,177).

Explanation of Age Pattern
Consistent Working-Age Lead
Across the municipalities in the selected records, Working Age (20-59) remains the largest group. This indicates a stable productive-age base in the local demographic profile.
Balanced Dependency Pressure
Dependency ratios around the mid-50% range suggest that dependent age groups are significant, but still supported by a larger working-age segment.
Service Planning Implication
With Youth at 29.8%, Working Age at 63.7%, and Senior at 6.4, program design should prioritize livelihood and employment support while sustaining child and senior-targeted services.
Supporting Evidence
1
PhilAtlas Laguna Profile
Regional and municipal demographic reference (Laguna)
View Source
Conclusion

The records indicate a consistent age-structure pattern where Working Age remains the largest segment, while Youth and Senior groups continue to contribute to dependency demand.

This supports a dual strategy: reinforce productivity-focused interventions and maintain social protection for younger and older dependents.

5. Household vs Population Analysis

Population vs Households Combo Chart

Bars = Population, Line = Households 2024

Average Household Size
Liliw 4.1 persons/hh
9,750 households · 39,976 pop.
Magdalena 4.66 persons/hh
6,050 households · 28,200 pop.
Majayjay 4.8 persons/hh
5,938 households · 28,503 pop.

6. Program Beneficiaries Analysis

PWD
Highest Demand Program
3,684 total beneficiaries
Liliw
5,700
Total Beneficiaries
Magdalena
2,862
Total Beneficiaries
Majayjay
3,173
Total Beneficiaries
Programs per Municipality (Stacked)

PWD, AICS, Solo Parent, 4Ps, Senior 2024

Beneficiaries Trend (Yearly)

Total beneficiaries over all years

Program LiliwMagdalenaMajayjay Total Highest
PWD 2,500 719 465 3,684 Liliw
AICS 468 1,544 398 2,410 Magdalena
Solo Parent 312 157 285 754 Liliw
4Ps 1,500 442 1,180 3,122 Liliw
Senior 920 0 845 1,765 Liliw

7. ANOVA Analysis

One-way ANOVA tests whether significant differences exist among municipalities (α = 0.05).

ANOVA Population
F-Statistic
61.3899
df (between / within)
2 / 6
Significant (p < 0.05)

There are statistically significant differences in population among the three municipalities. The observed differences are unlikely due to chance.

Group Means
Liliw
38,683
Magdalena
27,094
Majayjay
28,063
ANOVA Beneficiaries
F-Statistic
0.1432
df (between / within)
2 / 6
Not Significant (p > 0.05)

No statistically significant difference in beneficiaries was detected. The municipalities perform similarly relative to the variability in data.

Group Means
Liliw
1,900
Magdalena
954
Majayjay
1,058

8. Correlation Analysis

Pearson correlation (r) measures strength and direction of linear relationships.

Population vs Total Beneficiaries
0.3326
Weak Positive
Pearson r

Weak relationship Population and Beneficiaries show little linear dependency.

Age 60+ vs Senior Assistance
0.4418
Moderate Positive
Pearson r

Moderate positive relationship detected between Age 60+ Population and Senior Beneficiaries.

Households vs AICS
-0.1018
Weak Negative
Pearson r

Weak relationship Households and AICS Beneficiaries show little linear dependency.

9. Key Insights

Finding 1

Liliw has the highest population (39,976) while Magdalena has the lowest.

Finding 2

Magdalena shows the highest average population growth rate among the municipalities.

Finding 3

Liliw has the most registered beneficiaries (5,700) — 14.3% of its population.

Finding 4

The dominant age group across all municipalities is Working Age (20–59) — indicating a productive population.

Finding 5

A gender gap of 1,527 exists: Male-dominant (49069 M vs 47542 F).

Finding 6

The PWD program has the highest total beneficiaries (3,684) across all municipalities.

Finding 7

Dependency ratios: Liliw: 56.8%, Magdalena: 58.2%, Majayjay: 55.8% — higher ratio means more dependents per working-age person.

10. Recommendations

Priority Support

Magdalena has the smallest population base; ensure equitable distribution of welfare resources and avoid underserving this municipality.

Program Expansion

Expand the PWD program — it has the highest demand. Consider increasing budget allocation and outreach in all municipalities.

Age Intervention

Youth programs (education, livelihood) should be reinforced to empower the dominant 0–19 age bracket.

Gender Programs

Consider targeted programs for male residents who may be underrepresented in welfare enrollment.

Fastest Grower

Magdalena is growing fastest — proactively scale up social welfare infrastructure and staffing to meet rising demand.

AICS & Households

High AICS uptake correlates with household density. Increase crisis assistance (AICS) funding proportionally with household growth.