Study guide
3.1 Statistical Tables & Tabular Data Analysis
Career Executive Service CES
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Verbal Ability & Error Recognition
1.1 CES-WE Verbal Examination Overview & Error Recognition Scheme 1.2 Grammar & Syntax Rules in Executive Writing 1.3 Diction & Vocabulary Precision in Public Administration Contexts 1.4 Verbosity, Redundancy & Executive Conciseness
2 Chapter 2: Reading Comprehension & Information Extraction
2.1 Passages, Main Ideas & Executive Summarization 2.2 Textual Inference, Tone & Authorial Intent 2.3 Critical Analysis of Official Reports, Policy Papers & Case Studies 2.4 Time-Management Strategies for Lengthy Reading Passages
3 Chapter 3: Numerical & Data Interpretation
3.1 Statistical Tables & Tabular Data Analysis 3.2 Graphical Analysis: Bar, Line & Pie Charts in Public Reporting 3.3 Percentage, Ratio, Rate of Growth & Budget Calculations 3.4 Data-Driven Decision Making & Analytical Pitfalls
4 Chapter 4: Logical & Analytical Reasoning
4.1 Categorical Syllogisms & Formal Deductive Logic 4.2 Number, Letter & Pattern Series 4.3 Verbal & Concept Analogies in Management Scenarios 4.4 Argument Validity, Premises & Logical Fallacies
5 Chapter 5: Core Management Functions & Organizational Dynamics
5.1 Strategic & Operational Planning 5.2 Organizational Structure, Design & Delegation of Authority 5.3 Leadership Styles, Power Dynamics & Executive Influence 5.4 Motivation Theories in Public Sector Management 5.5 Organizational Control Systems & Performance Evaluation
6 Chapter 6: Executive Decision-Making & Public Management Problems
6.1 Decision-Making Models, Risk Analysis & Crisis Management 6.2 Public Sector Reform, Good Governance & New Public Management 6.3 Change Management & Conflict Resolution in Public Bureaucracy 6.4 Case Analysis Methodology for CES-WE Management Scenarios
7 Chapter 7: Philippine Constitution, State Structure & Public Ethics
7.1 The 1987 Philippine Constitution & Executive Branch Power 7.2 Legislative & Judicial Branches: Check and Balance Mechanisms 7.3 Constitutional Commissions (CSC, COA, COMELEC) & Oversight Bodies 7.4 RA 6713 (Code of Conduct and Ethical Standards for Public Officials) 7.5 Anti-Graft, Transparency Laws (RA 3019, FOI) & Public Accountability
8 Chapter 8: The Career Executive Service System & Executive Essay Writing
8.1 The CES System: Concept, Ranks, Eligibility & CESB Mandate 8.2 Structure & Scoring of the CES-WE Essay Sub-Test 8.3 Analytical Framing & Essay Outlining for Policy Issues 8.4 Model Essay Responses & Executive Writing Standards
3.1 Statistical Tables & Tabular Data Analysis
Key Takeaways Explain This Topic AI
Statistical tables organize quantitative data into rows and columns, requiring systematic analysis of titles, row/column stubs, unit multipliers, and footnotes before interpreting cell values.
Calculating row and column margin totals acts as a primary verification check to detect data discrepancies, rounding errors, or omitted sub-categories in official budget and census reports.
Unit multiplier oversights—such as confusing values expressed in thousands, millions, or billions of Philippine Pesos (PHP)—represent the single most frequent trap in civil service quantitative examinations.
Evaluating plantilla position vacancy rates requires dividing unfilled positions by total authorized positions, distinguishing actual staffing levels from approved budgetary ceilings.
Base-year indexing converts absolute tabular values into percentage proportions relative to a chosen reference period, enabling apples-to-apples trend comparisons across different agency scales.
Last updated: July 2026
3.1 Statistical Tables & Tabular Data Analysis
In executive civil service roles within the Philippine public sector, leaders are constantly required to evaluate dense tabular datasets—from Department of Budget and Management (DBM) National Expenditure Program matrices to Commission on Audit (COA) annual financial reports and Philippine Statistics Authority (PSA) demographic tables. Statistical tables compress massive volumes of quantitative information into structured rows and columns. Mastery over tabular data analysis requires not merely arithmetic skill, but a structured protocol to extract insight, verify internal consistency, and calculate rates of change rapidly under examination pressure.
Structural Anatomy of Public Sector Statistical Tables
To interpret a statistical table accurately, an executive must understand its formal structural elements:
Table Element Location / Feature Primary Analytical Function
Table Title & Caption Top of the table Defines the scope, geography, target subject, and reporting timeframe (e.g., FY 2020–2024).
Unit Multiplier / Headnote Top right or under title Specifies measurement scale (e.g., "In Millions of PHP" , "Per 100,000 Population" , "In Metric Tons" ).
Boxhead (Column Captions) Upper header row(s) Labels the variable or category presented in each vertical column, including sub-headers.
Stub (Row Labels) Leftmost column Defines horizontal line items, such as agency divisions, regional locations, or fiscal items.
Cells (Data Field) Intersection of row and column Contains the specific quantitative value, rate, ratio, or code indicator.
Margin Totals Bottom row and rightmost column Summarizes grand totals and category sub-totals; essential for cross-verification.
Footnotes & Source Notes Bottom of table Explains qualifiers, data modifications, missing data symbols ( "N.A." or "—" ), and data sources. STATISTICAL TABLE ANATOMY
- +------------------------------------------------------------------+
- | Title: Regional Budget Allocation (FY 2022-2024) [In Million ₱] | <-- Title & Multiplier
- +--------------------+-------------------+-------------------------+
- | Stub (Row Labels) | Boxhead (Column 1)| Boxhead (Column 2) | <-- Column Headers
- +--------------------+-------------------+-------------------------+
- | Region III (CL) | 12,450.5 | 14,100.0 | <-- Data Cells
- | Region IV-A (CAL) | 18,200.0 | 20,850.5 | <-- Data Cells
- +--------------------+-------------------+-------------------------+
- | Grand Total | 30,650.5 | 34,950.5 | <-- Margin Totals
- +--------------------+-------------------+-------------------------+
- | Source: DBM GAA Report (2024) | <-- Source & Footnotes
- +------------------------------------------------------------------+
- The 5-Step Systematic Tabular Analysis Protocol
When presented with a complex tabular dataset in the CES-WE, candidates should execute a 5-step systematic protocol before answering questions:
Orient via Title and Headnotes : Immediately verify the reporting entity, time horizon, and unit multiplier. Never assume numbers represent raw units; check if they are expressed in thousands, millions, or percentages.
Scan the Stub and Boxhead Hierarchy : Understand how variables are grouped. Distinguish main categories from indented sub-categories to prevent double counting.
Inspect Margin Totals : Check horizontal (row) totals and vertical (column) totals. Verifying margin totals ensures you understand whether numbers add up additively or represent non-additive averages.
Identify Anomalies and Trends : Look across rows and down columns to spot outlier figures, sudden spikes, sharp drops, or zero entries across comparative years.
Read Footnotes and Symbols : Verify symbol definitions (e.g., asterisks indicating revised estimates, or dashes indicating zero vs uncollected data).
Tabular Data Types in Public Administration
Executive civil service examinations feature three primary types of tabular datasets:
1. Multi-Year Fiscal Breakdown Tables
These tables track agency appropriations, allotments, obligations, and disbursements over multiple fiscal years. Key focus areas include identifying nominal expenditure shifts, growth trends, and unobligation rates.
2. Civil Service Personnel & Staffing Matrices
These matrices display authorized plantilla positions, filled positions, and vacant positions organized by Salary Grade (SG 1–10 Support, SG 11–24 Professional/Technical, SG 25–30 Executive/Managerial). Candidates are asked to evaluate vacancy rates and staffing fulfillment ratios.
3. Regional Socio-Economic & Demographic Tables
These tables combine geographic classifications (e.g., 17 administrative regions of the Philippines) with social indicators such as poverty incidence, literacy rates, and National Tax Allotment (NTA / IRA) shares.
- Step-by-Step Worked Calculation Examples
- Example 1: Agency Staffing & Vacancy Rate Table
Consider the following official personnel table for an executive department:
- Salary Grade Tier Authorized Plantilla Filled Positions Unfilled (Vacant) Positions
- SG 1–10 (Clerical/Support) 1,200 1,140 60
- SG 11–24 (Technical/Professional) 2,500 2,125 375
- SG 25–30 (Executive/Director) 300 255 45
- Total Department 4,000 3,520 480
Problem A : Calculate the overall Department Vacancy Rate and identify which Salary Grade tier has the highest proportional vacancy rate.
Solution :
Formula for Vacancy Rate : Vacancy Rate = ( Unfilled Positions Authorized Plantilla ) × 100 % \text{Vacancy Rate} = \left( \frac{\text{Unfilled Positions}}{\text{Authorized Plantilla}} \right) \times 100\% Vacancy Rate = ( Authorized Plantilla Unfilled Positions ) × 100%
Overall Department Vacancy Rate : Overall Vacancy Rate = ( 480 4 , 000 ) × 100 % = 0.12 × 100 % = 12.0 % \text{Overall Vacancy Rate} = \left( \frac{480}{4,000} \right) \times 100\% = 0.12 \times 100\% = 12.0\% Overall Vacancy Rate = ( 4 , 000 480 ) × 100% = 0.12 × 100% = 12.0%
Tier-by-Tier Vacancy Rate Calculation :
- SG 1–10 : 60 1 , 200 × 100 % = 5.0 % \frac{60}{1,200} \times 100\% = 5.0\% 1 , 200 60 × 100% = 5.0%
- SG 11–24 : 375 2 , 500 × 100 % = 15.0 % \frac{375}{2,500} \times 100\% = 15.0\% 2 , 500 375 × 100% = 15.0%
- SG 25–30 : 45 300 × 100 % = 15.0 % \frac{45}{300} \times 100\% = 15.0\% 300 45 × 100% = 15.0%
Conclusion : Both SG 11–24 and SG 25–30 share the highest proportional vacancy rate of 15.0% , while the overall department vacancy rate is 12.0% .
Example 2: Multi-Year Regional Development Budget Allocation
The table below presents regional infrastructure allocations (expressed in Millions of PHP ) from FY 2021 to FY 2024:
- Region FY 2021 FY 2022 FY 2023 FY 2024
- Region I (Ilocos) 4,500 4,950 5,445 5,989.5
- Region V (Bicol) 3,200 3,840 4,608 5,529.6
- Region VI (Western Visayas) 6,000 6,300 6,615 6,945.75
- Total Allocation 13,700 15,090 16,668 18,464.85
Problem B : Determine which region experienced the highest percentage growth in infrastructure allocation from FY 2021 to FY 2024.
Solution :
Formula for Total Percentage Growth : Percentage Growth = ( FY 2024 Value − FY 2021 Value FY 2021 Value ) × 100 % \text{Percentage Growth} = \left( \frac{\text{FY 2024 Value} - \text{FY 2021 Value}}{\text{FY 2021 Value}} \right) \times 100\% Percentage Growth = ( FY 2021 Value FY 2024 Value − FY 2021 Value ) × 100%
Region I Growth : Growth Region I = 5 , 989.5 − 4 , 500 4 , 500 × 100 % = 1 , 489.5 4 , 500 × 100 % = 33.10 % \text{Growth}_{\text{Region I}} = \frac{5,989.5 - 4,500}{4,500} \times 100\% = \frac{1,489.5}{4,500} \times 100\% = 33.10\% Growth Region I = 4 , 500 5 , 989.5 − 4 , 500 × 100% = 4 , 500 1 , 489.5 × 100% = 33.10%
Region V Growth : Growth Region V = 5 , 529.6 − 3 , 200 3 , 200 × 100 % = 2 , 329.6 3 , 200 × 100 % = 72.80 % \text{Growth}_{\text{Region V}} = \frac{5,529.6 - 3,200}{3,200} \times 100\% = \frac{2,329.6}{3,200} \times 100\% = 72.80\% Growth Region V = 3 , 200 5 , 529.6 − 3 , 200 × 100% = 3 , 200 2 , 329.6 × 100% = 72.80%
Region VI Growth : Growth Region VI = 6 , 945.75 − 6 , 000 6 , 000 × 100 % = 945.75 6 , 000 × 100 % = 15.76 % \text{Growth}_{\text{Region VI}} = \frac{6,945.75 - 6,000}{6,000} \times 100\% = \frac{945.75}{6,000} \times 100\% = 15.76\% Growth Region VI = 6 , 000 6 , 945.75 − 6 , 000 × 100% = 6 , 000 945.75 × 100% = 15.76%
Conclusion : Although Region VI had the largest absolute baseline allocation in FY 2021 (₱6,000M), Region V recorded the highest relative percentage growth at 72.80% over the four-year period.
Common Tabular Interpretation Traps & Exam Strategies
To maximize performance on tabular interpretation sub-tests:
Trap 1: The Scale & Multiplier Oversight : Candidates frequently read 4,500 in a table labeled "in Millions of PHP" as ₱4,500 rather than ₱4.5 Billion. Always verify final answer units against the table headnote.
Trap 2: Absolute vs Relative Growth Confusion : A larger base number experiencing a modest percentage increase can yield a high absolute change, whereas a small base number can show massive percentage growth despite small absolute gains. Read test stems carefully to know whether absolute peso value or percentage rate is asked.
Trap 3: Double Counting Sub-totals : In multi-tiered tables featuring indented sub-totals (e.g., Total Capital Outlay containing Buildings and Land Transport Equipment), never sum sub-totals together with parent category rows.
Trap 4: Rounding Intermediate Steps : When performing multi-step row calculations, retain at least two decimal places until the final calculation to prevent cumulative rounding distortion.