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: Social Welfare Programs · 2026 · Liliw, Magdalena, Majayjay
2. Year
2015 2020 2021 2022 2023 2024 2025 2026
Descriptive Analysis Program Beneficiaries Report & Download Key Insights Recommendations

Descriptive Analysis

Total Beneficiaries (2026)
8,864
Highest: Majayjay
Population, Households & Beneficiaries per Municipality

Grouped bar chart 2026

Program Beneficiaries Analysis

Senior Citizen Pension
Highest Demand Program
5,671 total beneficiaries
Liliw
3,457
Total Beneficiaries
Magdalena
N/A
No data for 2026
Majayjay
5,407
Total Beneficiaries
Programs per Municipality (Stacked)

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

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 200 N/A 296 496 Majayjay
AICS N/A N/A N/A N/A N/A
PWD Assistance 1,430 N/A 829 2,259 Liliw
Senior Citizen Pension 1,700 N/A 3,971 5,671 Majayjay
Solo Parent 127 N/A 311 438 Majayjay

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 2026; program records available 2015 to 2026
Dataset
Social Welfare Programs
Municipalities
Liliw, Magdalena, Majayjay
Recorded beneficiaries
8,864 (2 of 3 municipalities have records)
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 2026

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.
  • Overall AHP ranking for 2026 cannot be calculated because required annual data are N/A for: Magdalena / Senior Citizen Pension; Magdalena / PWD Assistance; Magdalena / Solo Parent. A valid overall ranking will become available when all required annual data have been entered.
  • Liliw: N/A for AICS in 2026; the total covers known programs only and does not represent every program.
  • Liliw: no census population for 2026, so beneficiaries as a share of population is not calculated. Census records exist for: 2015, 2020, 2024.
  • Magdalena: no usable annual program counts for 2026 (shown as N/A, not 0).
  • Majayjay: N/A for AICS in 2026; the total covers known programs only and does not represent every program.
  • Majayjay: no census population for 2026, so beneficiaries as a share of population is not calculated. Census records exist for: 2015, 2020, 2024.
  • 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
  • Magdalena / Senior Citizen Pension / 2026 — No annual record (month IS NULL) for this municipality, program, and year.
  • Magdalena / PWD Assistance / 2026 — No annual record (month IS NULL) for this municipality, program, and year.
  • Magdalena / Solo Parent / 2026 — No annual record (month IS NULL) for this municipality, program, and year.
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 2026 cannot be calculated because required annual data are N/A for: Magdalena / Senior Citizen Pension; Magdalena / PWD Assistance; Magdalena / Solo Parent. A valid overall ranking will become available when all required annual data have been entered.

Finding 2

Majayjay has the most registered beneficiaries (5,407).

Finding 3

The Senior Citizen Pension program has the highest total beneficiaries (5,671) across municipalities with data for 2026.

Finding 4

No official census population or household data is available for year 2026. Census records are available for: 2015, 2020, 2024.

Finding 5

PWD Assistance in 2026: highest known count is Liliw (1,430); lowest known count is Majayjay (829). Based on 2 of 3 municipalities with known annual data; this does not represent all three municipalities.

Finding 6

Senior Citizen Pension in 2026: highest known count is Majayjay (3,971); lowest known count is Liliw (1,700). Based on 2 of 3 municipalities with known annual data; this does not represent all three municipalities.

Finding 7

Solo Parent in 2026: highest known count is Majayjay (311); lowest known count is Liliw (127). Based on 2 of 3 municipalities with known annual data; this does not represent all three municipalities.

Finding 8

Liliw / 4Ps decreased from 250 in 2025 to 200 in 2026. Validate the records before treating this as a confirmed program change.

Finding 9

Liliw / PWD Assistance increased from 1,245 in 2025 to 1,430 in 2026. Validate the records before treating this as a confirmed program change.

Finding 10

Liliw / Senior Citizen Pension increased from 1,200 in 2025 to 1,700 in 2026. Validate the records before treating this as a confirmed program change.

Recommendations

Recommendation 1

Complete and validate the missing annual municipality/program records for 2026 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 Magdalena / Senior Citizen Pension / 2026.

Recommendation 3

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

Recommendation 4

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

Recommendation 5

The known Senior Citizen Pension counts in 2026 differ substantially across municipalities. Review the source records and confirm they are comparable before drawing conclusions.

Recommendation 6

The known Solo Parent counts in 2026 differ substantially across municipalities. Review the source records and confirm they are comparable before drawing conclusions.

Recommendation 7

Where year-to-year changes appear between 2025 and 2026, validate the records and check documented program changes before treating the difference as a confirmed increase or decrease in beneficiaries.