5.4 Data Interpretation — Tables, Graphs & Charts

5.4 Data Interpretation — Tables, Graphs & Charts

Data Interpretation (DI) is a core component of the HEC Aptitude Test (HAT) Quantitative Reasoning section. DI questions evaluate a candidate's ability to extract numerical values from tables, bar graphs, line charts, and pie charts, perform percentage and ratio calculations, synthesize information across multiple figures, and draw valid quantitative conclusions.

---

1. Multi-Column Data Tables

Tables present structured numerical data across labeled rows and columns. Solving tabular DI problems requires systematic cross-referencing.

Key Principles for Table Analysis

1. Identify Units & Scales: Verify whether table entries represent absolute counts, thousands, millions, percentages, or ratios.
2. Distinguish Row vs. Column Totals: Pay strict attention to whether a question asks for a percentage of a row total, column total, or grand total.
3. Weighted Averages: When combining group averages across subgroups of unequal size, use the weighted average formula: $\text{Weighted Average} = \frac{\sum (n_i \cdot \bar{x}_i)}{\sum n_i}$

Sample Tabular Data Set

Consider the quarterly revenue (in Million PKR) of four corporate divisions:

---

Worked Example 4.1: Tabular Percentage Analysis

Problem: Using the sample table above, what percentage of the company's total Q4 revenue was contributed by the Textiles division?

Step-by-Step Derivation:

1. Locate the Q4 revenue for the Textiles division: $190$ Million PKR.
2. Locate the total Q4 revenue across all divisions: $590$ Million PKR.
3. Calculate the percentage share: $\text{Percentage} = \left(\frac{190}{590}\right) \times 100\% = 0.32203... \times 100\% \approx 32.2\%$

---

2. Bar Charts: Single, Grouped & Stacked

Bar charts display categorical data using rectangular bars whose heights or lengths are proportional to their values.

Types of Bar Charts

• Single Bar Chart: Represents one data series across categories.
• Grouped (Clustered) Bar Chart: Displays multiple discrete data series side-by-side per category, allowing direct comparison.
• Stacked Bar Chart: Places sub-components on top of one another to form a single bar. The total bar height represents the cumulative sum, while individual segment heights represent constituent parts.

---

Worked Example 4.2: Stacked Bar Chart Analysis

Problem: A stacked bar chart shows a company's total annual operating expenses broken down into Salaries ($40%$ of bar), R&D ($35%$ of bar), and Utilities ($25%$ of bar). If total operating expenses were $5.0$ Million PKR, how much was spent on Salaries and Utilities combined?

Step-by-Step Derivation:

1. Combine the percentage shares for Salaries and Utilities: $\text{Combined Share} = 40\% + 25\% = 65\% = 0.65$
2. Multiply the combined percentage by the total expense figure: $\text{Combined Spending} = 0.65 \times 5,000,000 = 3,250,000 \text{ PKR (or } 3.25 \text{ Million PKR)}$

---

3. Line Graphs & Time Series Analysis

Line graphs track continuous quantitative data over sequential time intervals (time series). The slope of a line segment indicates the rate of change:

$\text{Rate of Change} = \frac{\Delta y}{\Delta t} = \frac{y_2 - y_1}{t_2 - t_1}$

Percentage Growth Rates

To compute the overall percentage change over a period:

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

---

Worked Example 4.3: Line Graph Growth Calculation

Problem: A line graph records an online store's user count as follows: Year 2021 ($20,000$ users), Year 2022 ($28,000$ users), Year 2023 ($35,000$ users), Year 2024 ($42,000$ users). Calculate the percentage increase from 2021 to 2024.

Step-by-Step Derivation:

1. Identify Initial Value ($2021$) $= 20,000$.
2. Identify Final Value ($2024$) $= 42,000$.
3. Calculate absolute increase: $\Delta y = 42,000 - 20,000 = 22,000$
4. Compute percentage increase: $\text{Percentage Increase} = \frac{22,000}{20,000} \times 100\% = 1.10 \times 100\% = 110\%$

---

4. Pie Charts & Angular Conversions

Pie charts show relative proportions of a whole divided into sector slices. The complete circle represents $100%$ or $360^\circ$.

Conversion Formulas

1. Degree to Percentage: $\text{Percentage} = \left(\frac{\theta}{360^\circ}\right) \times 100%$
2. Percentage to Degree: $\text{Central Angle } \theta = \left(\frac{\text{Percentage}}{100%}\right) \times 360^\circ$
3. Degree to Absolute Value: $\text{Value} = \left(\frac{\theta}{360^\circ}\right) \times \text{Total}$

---

Worked Example 4.4: Pie Chart Angular Conversion

Problem: In a municipal budget pie chart, the Education sector has a central angle of $108^\circ$. If the total municipal budget is $50$ Million PKR, what amount is allocated to Education?

Step-by-Step Derivation:

1. Calculate the fraction of the circle occupied by Education: $\text{Fraction} = \frac{108^\circ}{360^\circ} = \frac{3}{10} = 0.30$
2. Multiply the fraction by the total budget: $\text{Allocation} = 0.30 \times 50,000,000 = 15,000,000 \text{ PKR (or } 15 \text{ Million PKR)}$

---

5. Multi-Step Integrated DI Strategies

When facing multi-figure or multi-step DI questions on the HAT:

1. Read Question First: Identify the specific metrics needed before diving into complex charts.
2. Avoid Rounding Prematurely: Carry exact fractions or decimal places through intermediate steps and round only at the final answer.
3. Check Estimation Options: When answer choices are widely separated, rough mental estimation can eliminate incorrect options quickly without heavy long division.