Statistical Analysis Dashboard

Comparative Socioeconomic Analysis

Comparative statistical analysis of municipalities in Laguna Province covering population, households, and social welfare programs. Supporting MSWDO planning, assessment, and decision-making.

Get the App
Liliw • Magdalena • Majayjay
Laguna Province
1. Dataset
Population & Households Social Welfare Programs All Data
Viewing: All Data · 2015 · Liliw, Magdalena, Majayjay
2. Year
2015 2020 2021 2022 2023 2024 2025 2026
Descriptive Analysis Population Growth Household vs Population Program Beneficiaries Report & Download Key Insights Recommendations

Descriptive Analysis

Total Population (2015)
89,417
Highest: Liliw
Total Households (2015)
21,714
Highest: Liliw
Total Beneficiaries (2015)
N/A
No program data for 2015
Population, Households & Beneficiaries per Municipality

Grouped bar chart 2015

Key Differences
Municipality Population Benef. %
Liliw 36,359 N/A
Magdalena 25,266 N/A
Majayjay 27,792 N/A

Liliw leads in population. Program beneficiary records are not collected for 2015.

Population Growth Analysis

Population per Year per Municipality

Line chart all recorded years

Growth Rates
Liliw +8.31%
Avg. yearly growth
Magdalena +9.58%
Avg. yearly growth
Majayjay +0.36%
Avg. yearly growth

Magdalena shows the fastest average population growth among the municipalities.

Key Finding

Magdalena shows the highest average yearly population growth rate at +9.58%, based on the available population records.

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.

Household vs Population Analysis

Population vs Households Combo Chart

Bars = Population, Line = Households 2015

Average Household Size
Liliw 3.92 persons/hh
9,265 households · 36,359 pop.
Magdalena 4.34 persons/hh
5,825 households · 25,266 pop.
Majayjay 4.2 persons/hh
6,624 households · 27,792 pop.

Program Beneficiaries Analysis

No program beneficiary data available for 2015
Program beneficiary records cover: 20152026.
N/A
Highest Demand Program
No program data for 2015
Liliw
N/A
No data for 2015
Magdalena
N/A
No data for 2015
Majayjay
N/A
No data for 2015
Programs per Municipality (Stacked)

4Ps, AICS, PWD Assistance, Senior Citizen Pension, Solo Parent 2015

Beneficiaries Trend (Yearly)

Total beneficiaries over all years

Note: Only usable annual counts are shown. Missing records and stored 0 are N/A, not zero beneficiaries.
Program LiliwMagdalenaMajayjay Total Highest
4Ps N/A N/A N/A N/A N/A
AICS N/A N/A N/A N/A N/A
PWD Assistance N/A N/A N/A N/A N/A
Senior Citizen Pension N/A N/A N/A N/A N/A
Solo Parent N/A N/A N/A N/A N/A

Totals use known annual counts only. Any N/A cell (missing record or stored 0) means the total does not represent all three municipalities.

Analysis Report & Download

Social Welfare Programs Analysis Report
Reporting period
Reporting year 2015; program records available 2015 to 2026
Dataset
All Data (programs report)
Municipalities
Liliw, Magdalena, Majayjay
Recorded beneficiaries
N/A — no program records for 2015
The report contains
  • Title, reporting period, dataset, municipalities and date generated
  • Data summary and tables: beneficiaries by program, municipality summary, yearly totals
  • Methodology, AHP-weighted ranking, recommendations, and limitations / missing-data notes

Report for 2015

Read it here, or download a copy. Every format matches the selected dataset and year.

Data Notes & Limitations
  • Figures are annual beneficiary counts (month IS NULL). Stored 0, NULL, and missing annual records are shown as N/A because they mean data have not yet been entered. They are not treated as verified zero beneficiaries.
  • Monthly program rows are not added to annual municipality totals. Soft-deleted records are excluded.
  • No budget, unit cost, eligibility, need or outcome data are used, so the counts describe recorded reach only and do not measure program effectiveness.
  • The records do not state whether a person who receives more than one program is counted once or once per program, so the total across programs may not equal the number of unique persons.
  • No usable annual program beneficiary counts exist for 2015; every program figure is N/A.
  • Overall AHP ranking for 2015 cannot be calculated because required annual data are N/A for: Liliw / Senior Citizen Pension; Liliw / PWD Assistance; Liliw / Solo Parent; Magdalena / Senior Citizen Pension; Magdalena / PWD Assistance; Magdalena / Solo Parent; Majayjay / Senior Citizen Pension; Majayjay / PWD Assistance; Majayjay / Solo Parent. A valid overall ranking will become available when all required annual data have been entered.
  • Years without usable annual counts appear as N/A. Yearly totals may cover different municipalities and program types, so compare years with care. A change from N/A to a positive count is not a confirmed increase.
  • Comparative ranking covers Liliw, Magdalena, and Majayjay only.
AHP-Weighted Comparative Ranking
AHP: Not computed

AHP-weighted comparative score based on beneficiary counts

The score is an AHP-weighted comparative score based on beneficiary counts using approved AHP criteria weights. It does not measure poverty severity, program effectiveness, or unmet need.

Required annual values that are N/A
  • Liliw / Senior Citizen Pension / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Liliw / PWD Assistance / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Liliw / Solo Parent / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Magdalena / Senior Citizen Pension / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Magdalena / PWD Assistance / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Magdalena / Solo Parent / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Majayjay / Senior Citizen Pension / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Majayjay / PWD Assistance / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
  • Majayjay / Solo Parent / 2015 — Annual record exists but beneficiary_count is 0 or null (treated as N/A).
Approved criteria weights
  • Senior Citizen Pension: raw 0.3737, effective 0.373737
  • PWD Assistance: raw 0.3271, effective 0.327133
  • Solo Parent: raw 0.2991, effective 0.299130
AHP calculation details
Methodology
  1. The overall ranking uses approved AHP criteria weights from pairwise comparisons of 10 respondents. Weights are not recalculated from beneficiary counts.
  2. Approved raw weights: Senior Citizen Pension raw 0.3737, effective 0.373737; PWD Assistance raw 0.3271, effective 0.327133; Solo Parent raw 0.2991, effective 0.29913. Each raw weight is divided by the total (0.9999) so effective weights sum to 1.0.
  3. AICS and other programs may appear in descriptive tables when annual data exist, but they are excluded from the three-criterion AHP score.
  4. Only annual municipality-level records are used (month IS NULL, not soft-deleted). Monthly slices are never added to annual totals.
  5. A stored beneficiary_count of 0, NULL, or a missing annual record is N/A (data not yet entered) and is never treated as zero beneficiaries.
  6. N(i,j) = (X(i,j) - min(X(j))) / (max(X(j)) - min(X(j))) across Liliw, Magdalena, and Majayjay. Score(i) = Σ effectiveWeight(j) × N(i,j), displayed on a 0–100 scale.
  7. If all three valid values for a criterion are equal, each municipality receives a normalized value of 1 for that criterion so no municipality gains an artificial advantage.
  8. Duplicate active annual rows for the same municipality, year, and program are not summed. The row with the highest id is used.
  9. A complete overall ranking requires a valid annual count greater than zero for Senior Citizen Pension, PWD Assistance, and Solo Parent in every municipality. Missing values are not replaced with zero and weights are not renormalized over a subset of criteria.

Key Insights

Finding 1

Overall AHP ranking for 2015 cannot be calculated because required annual data are N/A for: Liliw / Senior Citizen Pension; Liliw / PWD Assistance; Liliw / Solo Parent; Magdalena / Senior Citizen Pension; Magdalena / PWD Assistance; Magdalena / Solo Parent; Majayjay / Senior Citizen Pension; Majayjay / PWD Assistance; Majayjay / Solo Parent. A valid overall ranking will become available when all required annual data have been entered.

Finding 2

No usable program beneficiary data is available for year 2015 (missing records and stored 0 are N/A). Program beneficiary records cover: 2015 - 2026.

Finding 3

Liliw has the highest population (36,359) while Magdalena has the lowest.

Finding 4

Liliw has N/A annual data for 4Ps, AICS, PWD Assistance, Senior Citizen Pension, Solo Parent in 2015.

Finding 5

Magdalena has N/A annual data for 4Ps, AICS, PWD Assistance, Senior Citizen Pension, Solo Parent in 2015.

Finding 6

Majayjay has N/A annual data for 4Ps, AICS, PWD Assistance, Senior Citizen Pension, Solo Parent in 2015.

Finding 7

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

Finding 8

Average household sizes: Liliw: 3.92, Magdalena: 4.34, Majayjay: 4.2 persons per household.

Recommendations

Recommendation 1

Complete and validate the missing annual municipality/program records for 2015 before relying on an overall AHP ranking. Required data: Senior Citizen Pension, PWD Assistance, and Solo Parent for Liliw, Magdalena, and Majayjay.

Recommendation 2

Enter a validated annual beneficiary count greater than zero for Liliw / Senior Citizen Pension / 2015.

Recommendation 3

Enter a validated annual beneficiary count greater than zero for Liliw / PWD Assistance / 2015.

Recommendation 4

Enter a validated annual beneficiary count greater than zero for Liliw / Solo Parent / 2015.

Recommendation 5

Enter a validated annual beneficiary count greater than zero for Magdalena / Senior Citizen Pension / 2015.

Recommendation 6

Enter a validated annual beneficiary count greater than zero for Magdalena / PWD Assistance / 2015.

Recommendation 7

Enter a validated annual beneficiary count greater than zero for Magdalena / Solo Parent / 2015.

Recommendation 8

Enter a validated annual beneficiary count greater than zero for Majayjay / Senior Citizen Pension / 2015.

Recommendation 9

Enter a validated annual beneficiary count greater than zero for Majayjay / PWD Assistance / 2015.

Recommendation 10

Enter a validated annual beneficiary count greater than zero for Majayjay / Solo Parent / 2015.