5.3 Data Interpretation: Tables, Bar Graphs, Line Graphs, and Pie Charts

5.3 Data Interpretation: Tables, Bar Graphs, Line Graphs, and Pie Charts

Data Interpretation questions evaluate three distinct competencies: (1) reading complex tabular and graphical structures accurately, (2) selecting the appropriate mathematical relationship required by the question stem, and (3) executing mental arithmetic shortcuts to eliminate distractors under your practice time limit.

---

Core Graphical Formats in Public Administration

Examinees must master four principal graphical formats:

1. Complex Tabular Displays (Cross-Tabulations)

Tables present dense numerical data cross-referenced across rows and columns. When analyzing tables, establish the reference basis immediately:

• Row Margins vs. Column Margins: Determine whether the percentages in each cell represent a share of the row total, the column total, or the grand total.
• Derived Indices: Some columns display derived ratios or percentage changes rather than absolute numbers. Never add percentages across columns unless they share an identical common denominator.

2. Bar Graphs: Clustered vs. Stacked

• Clustered (Grouped) Bar Graphs: Compare multiple distinct categories across different time periods (e.g., bilateral trade exports vs. imports from 2020 to 2025). The primary analytical task is tracking the widening or narrowing gap between bars.
• Stacked (Segmented) Bar Graphs: Display both the overall total (represented by the full height of the bar) and the relative proportional contribution of each component sub-category. To find the absolute value of an internal segment, subtract the baseline value at the bottom of that segment from the value at its top boundary.

3. Line Graphs: Multi-Variable Trends and Slopes

Line graphs visualize continuous trends over time. The steepness (slope) of a line segment represents the rate of change ($\Delta y / \Delta x$). Key features include:

• Trend features: A turning point reverses direction; an inflection point changes concavity. These are distinct features.
• Intersection Points: Coordinates where two separate variables reach exact quantitative parity.

4. Pie Charts: Angular Proportions and Sector Shares

A pie chart represents a closed whole where the entire circle equals $100\%$ and subtends a total central angle of $360^\circ$:

$$1\% = \frac{360^\circ}{100} = 3.6^\circ \quad \Longleftrightarrow \quad 1^\circ = \frac{100\%}{360} = \frac{5}{18}\% \approx 0.278\%$$

To compute the absolute numerical value of a sector given its central angle $\theta$ and total population/budget $T$:

$$\text{Sector Value} = T \times \left(\frac{\theta}{360^\circ}\right)$$ $$\begin{array}{lcl} 90^\circ = 25.0\% = \frac{1}{4} & \quad & 45^\circ = 12.5\% = \frac{1}{8} \\[6pt] 72^\circ = 20.0\% = \frac{1}{5} & \quad & 36^\circ = 10.0\% = \frac{1}{10} \\[6pt] 54^\circ = 15.0\% = \frac{3}{20} & \quad & 18^\circ = 5.0\% = \frac{1}{20} \end{array}$$

---

Essential Mathematical Formulas for Data Interpretation

Percentage change, percentage-point difference, and weighted averages are useful foundational calculations. No official item-frequency claim is made for them.

1. Percentage Change

$$\text{Percentage Change} = \left(\frac{\text{New Value} - \text{Base Value}}{\text{Base Value}}\right) \times 100\%$$

2. Percentage Points vs. Percentage Change

When examining economic indicators already expressed as percentages (such as tariff rates, inflation, or interest rates), distinguish between percentage points and relative percentage change:

• If an import tariff decreases from $25.0\%$ to $15.0\%$, the change is an absolute reduction of 10.0 percentage points ($25.0 - 15.0 = 10.0$).
• However, the relative percentage decrease in the tariff rate is:

$$\frac{25.0 - 15.0}{25.0} \times 100\% = \frac{10.0}{25.0} \times 100\% = 40.0\%$$

Test-makers intentionally place both $10.0\%$ and $40.0\%$ in the answer choices to penalize examinees who conflate these concepts.

3. Weighted Average

When combining multiple sub-groups that have different population sizes or processing volumes, you cannot take a simple unweighted arithmetic mean of their individual rates. You must calculate the weighted average ($\bar{x}_w$):

$$\bar{x}_w = \frac{\sum_{i=1}^{k} w_i x_i}{\sum_{i=1}^{k} w_i} = \frac{w_1 x_1 + w_2 x_2 + \dots + w_k x_k}{w_1 + w_2 + \dots + w_k}$$

Where $w_i$ represents the volume or weight of group $i$, and $x_i$ represents its rate or average.

---

Speed Estimation and Mental Math Bounding

Under strict time constraints, avoid lengthy long division. Use these mental estimation shortcuts:

1. Percentage Decomposition ($10\% + 1\%$ Rule)

To find any percentage of a large number mentally, break it into $10\%$, $5\%$, and $1\%$ increments:

• What is $16\%$ of PHP 450,000?
  • $10\% = 45,000$
  • $5\% = 22,500$ (half of $10\%$)
  • $1\% = 4,500$ (one-tenth of $10\%$)
  • Sum: $45,000 + 22,500 + 4,500 = \text{PHP } 72,000$

2. Benchmark Fractions Reference

Familiarize yourself with benchmark fraction-to-decimal equivalents:

3. Order-of-Magnitude Bounding

Round large numbers to two significant figures to establish upper and lower boundaries. If asked to evaluate $\frac{48,721}{198,400}$, approximate as $\frac{49,000}{200,000} = \frac{49}{200} = 24.5\%$. In the vast majority of items, distractors are spaced widely apart (e.g., $18\%$, $25\%$, $32\%$, $41\%$), making rigorous manual division unnecessary.

Precision note: Repeating decimal and percentage values in the benchmark table are rounded. A turning point reverses an upward/downward trend; an inflection point changes concavity and need not reverse the trend. Equal-looking slopes also require checking the axis scales. Use exact fractions until the final rounding when close answer choices matter.