Study guide
5.1 Line Graphs, Time Series & Trend Analysis
Irish Public Service Numerical Reasoning Test Study Guide Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Test Overview, Structure & Assessment Strategies
1.1 Test Overview, Structure & Administration 1.2 Pacing, Time Management & Exam Strategies 1.3 Assessment Interfaces, Tabbed Layouts & 'Cannot Say' Logic
2 Chapter 2: Core Arithmetic, Fractions & Decimals
2.1 Order of Operations & Mental Arithmetic Techniques 2.2 Fractions & Rational Numbers in Public Administration 2.3 Decimals, Rounding & Unit Conversions
3 Chapter 3: Percentages, Ratios & Proportions
3.1 Percentage Calculation & Base Identification 3.2 Percentage Change, Reverse Percentages & Multipliers 3.3 Ratios, Partitioning & Proportional Allocation 3.4 Rates, Staffing Metrics & Weighted Averages
4 Chapter 4: Statistical Tables & Bar Charts
4.1 Tabular Data Interpretation & Footnote Traps 4.2 Bar Charts, Clustered Bars & Segmented Stacks 4.3 Histograms & Frequency Distributions in Civil Service Reporting
5 Chapter 5: Line Graphs, Pie Charts & Multi-Source Synthesis
5.1 Line Graphs, Time Series & Trend Analysis 5.2 Pie Charts & Proportional Sector Expenditure 5.3 Multi-Source Data Synthesis & Cross-Referencing
6 Chapter 6: Financial Computations & Public Expenditure
6.1 Public Sector Budgeting, Allocation & Variance Analysis 6.2 Unit Costing, Service Delivery & Economies of Scale 6.3 Taxation, VAT & Net-to-Gross Calculations 6.4 Inflation, Indexation & Real vs Nominal Values
7 Chapter 7: Numerical Series, Sequences & Rapid Estimation
7.1 Arithmetic, Geometric & Two-Stage Number Sequences 7.2 Interleaved, Fibonacci & Pattern Recognition Series 7.3 High-Speed Estimation, Rounding & Order-of-Magnitude Filtering 7.4 Distractor Analysis, Unit Verification & Sanity Checking
5.1 Line Graphs, Time Series & Trend Analysis
Key Takeaways Explain This Topic AI
Dual-axis line graphs plot two distinct series against separate vertical scales; matching each curve to its corresponding left or right axis is essential to avoid orders-of-magnitude errors.
Slope indicates rate of change (marginal velocity), whereas vertical position indicates absolute volume; a flattening upward curve denotes slowing growth, not a budgetary or operational contraction.
Average Annual Growth Rate (AAGR) measures the uncompounded arithmetic mean of yearly percentage changes, whereas Compound Annual Growth Rate (CAGR) measures geometric expansion between endpoints.
Compare equivalent periods across years when a recurring calendar pattern may affect the data; a YoY comparison is not formal seasonal adjustment or proof of a lasting trend.
Historical values do not guarantee future values; calculate a forecast only under the task’s stated model or estimation instructions.
Last updated: October 2026
Time Series Dynamics in Public Administration
A time-series line chart plots a quantity against time. This section uses hypothetical administrative data to practise reading levels, interval changes, annual growth and recurring patterns. Use the format and timing specified for your competition rather than a universal seconds-per-item assumption.
Dual-Axis Graph Architecture & Scale Alignment
A dual-axis graph , also called a secondary-axis chart, requires careful matching of series and scales. These displays feature two independent vertical axes sharing a common chronological base:
Primary Vertical Axis (Left y y y -axis): Typically calibrated to financial or macroeconomic volume (e.g., Gross Expenditure in € millions).
Secondary Vertical Axis (Right y y y -axis): Often calibrated to operational activity, client caseloads, or percentage indices (e.g., Applications Processed in thousands, or Staff Full-Time Equivalents).
For a hypothetical display with linear axes 0–50 on the left and 0–200 on the right, the same physical height maps to different values:
- Left-axis reading (€ millions) Right-axis reading (thousands of inquiries)
- 35 140
- 42 168
The legend determines which scale belongs to a series. The shared vertical position does not make euros and inquiries interchangeable or prove a relationship between them.
The Scale Alignment Rule
A point at the right-axis reading 140 means 140,000 inquiries for the inquiry series. The corresponding left-axis position may read 35, but that does not mean 35 inquiries or €140 million. Match each series to the labelled scale and unit before calculating.
Important
Before performing any arithmetic, verify curve attribution by checking line formatting (e.g., solid versus dashed lines, square versus circular markers) against the chart legend. Always trace the selected curve directly to its designated axis.
Truncated Axes and Zero-Suppression Traps
A line chart need not have a zero origin. A narrow vertical scale can make a small change look steep, so inspect the labelled range and time spacing rather than judging a percentage change by the line’s angle. Always calculate differences using absolute coordinates rather than visual slopes.
Evaluating Trends: Rate of Change vs. Absolute Level
A critical conceptual requirement in public sector quantitative evaluation is separating the absolute volume level from the rate of change (the slope):
Absolute Level: The precise vertical coordinate of a data point at time t t t .
Slope (Rate of Change): The steepness and direction of the line segment connecting two points, representing marginal velocity: Slope ( m ) = Δ y Δ x = y 2 − y 1 x 2 − x 1 \text{Slope } (m) = \frac{\Delta y}{\Delta x} = \frac{y_2 - y_1}{x_2 - x_1} Slope ( m ) = Δ x Δ y = x 2 − x 1 y 2 − y 1
The "Flattening Curve" Fallacy
When an upward-sloping curve flattens—transitioning from a steep incline to a gentler positive slope—candidates often conclude that the metric has "declined." This is false. As long as the slope remains positive ( m > 0 m > 0 m > 0 ), the absolute volume continues to expand. A flattening curve signifies decelerating growth , meaning the metric is still increasing, but at a reduced pace.
Inflection Points
For a continuous curve, an inflection point is where concavity changes: from bending upward to bending downward, or conversely. A zero second derivative alone does not establish such a change. Annual observations connected by line segments do not determine a unique smooth curve or exact inflection point.
For sampled yearly data, describe what is known: which interval has the greatest increase, and whether subsequent increments become smaller. A peak in the observed annual increment is not proof of a calculus inflection at the labelled year, nor proof that total adoption has peaked.
Mathematical Formulations: Slope, AAGR, and CAGR
Two different summaries of multi-year change are:
1. Average Annual Growth Rate (AAGR)
AAGR is the arithmetic mean of individual annual percentage growth rates across n n n consecutive intervals: AAGR = 1 n ∑ t = 1 n g t = g 1 + g 2 + ⋯ + g n n \text{AAGR} = \frac{1}{n} \sum_{t=1}^n g_t = \frac{g_1 + g_2 + \dots + g_n}{n} AAGR = n 1 ∑ t = 1 n g t = n g 1 + g 2 + ⋯ + g n For positive preceding values, each single-year percentage growth rate g t g_t g t is: g t = ( y t − y t − 1 y t − 1 ) × 100 g_t = \left(\frac{y_t - y_{t-1}}{y_{t-1}}\right) \times 100 g t = ( y t − 1 y t − y t − 1 ) × 100
2. Compound Annual Growth Rate (CAGR)
For positive endpoints and n > 0 n>0 n > 0 annual intervals, CAGR is the constant compounded annual rate joining the endpoints. Four annual observations contain three intervals. The formula gives a decimal rate; multiply by 100 to express it as a percentage: CAGR = ( y n y 0 ) 1 n − 1 \text{CAGR} = \left(\frac{y_n}{y_0}\right)^{\frac{1}{n}} - 1 CAGR = ( y 0 y n ) n 1 − 1
Worked Administrative Example: Regulatory Agency Spend
Consider an environmental monitoring agency whose gross annual expenditure evolved as follows:
- 2021: €20.0 million
- 2022: €24.0 million ( g 1 = + 20.0 % g_1 = +20.0\% g 1 = + 20.0% )
- 2023: €27.6 million ( g 2 = + 15.0 % g_2 = +15.0\% g 2 = + 15.0% )
- 2024: €30.36 million ( g 3 = + 10.0 % g_3 = +10.0\% g 3 = + 10.0% )
Calculating the performance indicators:
Linear Change: y 3 − y 0 = EUR 30.36 m − EUR 20.0 m = + EUR 10.36 m y_3 - y_0 = \text{EUR }30.36\text{m} - \text{EUR }20.0\text{m} = +\text{EUR }10.36\text{m} y 3 − y 0 = EUR 30.36 m − EUR 20.0 m = + EUR 10.36 m .
Total Multi-Year Percentage Growth: ( 30.36 − 20.0 20.0 ) × 100 = + 51.8 % \left(\frac{30.36 - 20.0}{20.0}\right) \times 100 = +51.8\% ( 20.0 30.36 − 20.0 ) × 100 = + 51.8% .
AAGR: 20.0 % + 15.0 % + 10.0 % 3 = 45.0 % 3 = 15.0 % \frac{20.0\% + 15.0\% + 10.0\%}{3} = \frac{45.0\%}{3} = 15.0\% 3 20.0% + 15.0% + 10.0% = 3 45.0% = 15.0% .
CAGR: ( 30.36 / 20.0 ) 1 / 3 − 1 = ( 1.518 ) 1 / 3 − 1 ≈ 14.93 % (30.36 / 20.0)^{1/3} - 1 = (1.518)^{1/3} - 1 \approx 14.93\% ( 30.36/20.0 ) 1/3 − 1 = ( 1.518 ) 1/3 − 1 ≈ 14.93% .
The two summaries answer different questions. The CAGR reproduces the ending value when compounded for three years; the arithmetic average of the varying annual rates need not do so.
Operational Seasonality vs. Secular Trends
A seasonal pattern repeats around similar parts of the calendar. A hypothetical applications series may rise before summer and fall later in the year. A trend concerns a longer-term direction, while one-off events can also affect observations.
Compare like quarters across years to reduce the effect of a repeated calendar pattern. This is not itself a formal seasonal-adjustment method, and one positive year-on-year comparison does not prove a lasting structural trend. In the quiz dataset, every quarter and the annual total are 15% higher in the second year, although Q3 is below Q2 in both years. Those facts undermine a conclusion of general contraction from that quarter-to-quarter drop alone.
Formal seasonal adjustment estimates and removes recurring calendar effects. Use adjusted data or a supplied model when the question requires that analysis; do not invent an adjustment from two observations.
Avoiding the Extrapolation Trap
Psychometric test designers test whether candidates recognize the boundaries of provided data. If a graph displays historic operational volumes from 2020 through 2024, questions may ask: "Will agency expenditure exceed €45 million in 2026?"
For a task requiring conclusions from supplied historical data alone, a future value is not established without an applicable forecast, rule or other sufficient constraint. If a model is supplied, calculate its conditional prediction and identify it as a forecast rather than an observed fact. A question may also explicitly ask you to estimate; follow that instruction without treating the estimate as certain.
Trend Indicators & Interpretation Reference
Graphical Indicator Visual Appearance Mathematical Property Administrative Meaning Common Distractor Trap
Positive Linear Slope Straight line angled upward Δ y Δ x = k > 0 \frac{\Delta y}{\Delta x} = k > 0 Δ x Δ y = k > 0 Constant uniform increase per time unit Assuming percentage growth is constant (it actually declines as base expands)
Decelerating Upward Curve Upward curve flattening out d y d t > 0 , d 2 y d t 2 < 0 \frac{dy}{dt} > 0,\; \frac{d^2y}{dt^2} < 0 d t d y > 0 , d t 2 d 2 y < 0 Metric is expanding, but growth rate is slowing down Claiming operational volumes or budgets are declining
Inflection Point (continuous curve) Concavity changes A change of concavity is required; a zero second derivative alone is insufficient Change in how the slope evolves Inferring an exact inflection from annual samples or a fixed adoption threshold
Dual-Axis Misalignment Crossing or divergent curves Distinct left and right vertical scales Independent metrics with separate units Reading metric values off the opposing vertical scale
Seasonal Cyclicality Periodic wave-like oscillation Repeating quarterly/monthly peaks Regular operational workload cycles Mistaking seasonal dips for structural contractions
Tip
When evaluating multiple-choice options under tight time constraints, first eliminate any choice that confuses a slowing positive growth rate with an absolute decline.