Civil Service Numerical Reasoning Test Data Interpretation: Tables Syllabus

Data Interpretation: Tables syllabus — full chapter and topic list

Expand any chapter to see its topics and sub-topics. This is the whole examinable outline for Data Interpretation: Tables in Civil Service Numerical Reasoning Test, not a summary of it.

1. 1

   Reading and Navigating Tables

   3 topics

   • Locating exact values
     • Row and column intersection
     • Reading footnotes and headers carefully
   • Understanding table structure
     • Subtotals, totals and grand totals
     • Multi-tier and grouped column headings
   • Handling units and scaling notes
     • Values in £000s, millions or percentages
2. 2

   Single-Table Calculations

   4 topics

   • Totals, subtotals and differences
     • Summing rows or columns
     • Net change between two figures
   • Percentages and shares from table data
     • Each category as a share of the total
   • Averages from tabulated data
     • Mean across a row or column
   • Ratios and rates from table values
3. 3

   Multi-Table and Cross-Referenced Questions

   3 topics

   • Combining data from two or more tables
     • Matching categories across tables
     • Using one table to convert values in another
   • Multi-step linked calculations
     • Carrying an intermediate result forward
   • Identifying the relevant data only
     • Ignoring distractor rows and columns
4. 4

   Trends and Comparisons in Tables

   3 topics

   • Year-on-year and period-on-period change
     • Absolute change versus percentage change
   • Ranking and ordering values
     • Largest, smallest and nth highest
   • Spotting the largest change or anomaly

Data Interpretation: Tables flashcards for Civil Service Numerical Reasoning Test

18 of 50 cards from the Data Interpretation: Tables deck — real questions with worked answers.

1. In a data table, what is the difference between a row and a column, and how do you locate a single exact value?

   A row runs horizontally (one record/category); a column runs vertically (one variable/field). To locate an exact value, find the correct row label, trace across to the correct column heading, and read the cell where they intersect.

2. What is the standard reading order for finding a value at the intersection of a labelled row and column?

   Identify the row label first, then move along that row until you reach the required column heading. The value sits in the cell where the row and column meet.

3. When a table has both row totals and column totals, where is the grand total usually found?

   In the bottom-right corner cell, where the final 'Total' row and final 'Total' column intersect.

4. What is a header row (or column heading) in a data table?

   The top row (or label cells) that names what each column contains, defining the variable, category, units, or time period for the values below.

5. Why must you always read the units note or column heading before doing a calculation with table data?

   Because values may be expressed in thousands, millions, percentages, or specific units; ignoring the scaling note leads to answers that are wrong by a factor of 10, 100, 1000, etc.

6. A table is headed 'Figures in £000s' and a cell shows 45. What is the actual value?

   $45 \times 1000 = \pounds 45{,}000$.

7. A table states 'All figures in millions'. A cell reads 3.2. What is the true number?

   $3.2 \times 1{,}000{,}000 = 3{,}200{,}000$.

8. How do you convert a value given 'in thousands' back to absolute units?

   Multiply the tabulated figure by 1000. For example, a value of $7.5$ in thousands equals $7{,}500$.

9. If one table column is in thousands and another is in millions, what must you do before combining them?

   Convert both to the same unit (e.g. express everything in absolute units or all in thousands) so the scales match before adding, subtracting, or comparing.

10. What is the formula for the total of a set of table values $x_1, x_2, \dots, x_n$?

    $$\text{Total} = \sum_{i=1}^{n} x_i = x_1 + x_2 + \cdots + x_n$$

11. What is the difference between a subtotal and a grand total in a table?

    A subtotal is the sum of values within one group or category; the grand total is the sum of all subtotals (or all values), covering the entire table.

12. How do you find the difference between two table values, and why does order matter?

    Subtract one value from the other: $\text{difference} = a - b$. Order matters for sign — to express 'how much more A is than B' compute $a - b$; the absolute difference is $|a - b|$.

13. A column total is 480 and three of its four entries are 120, 95 and 130. What is the missing entry?

    $480 - (120 + 95 + 130) = 480 - 345 = 135$.

14. What is the formula to express a table value $x$ as a percentage of a total $T$?

    $$\text{Percentage} = \frac{x}{T} \times 100\%$$

15. In a table, 36 of a total of 150 respondents chose option A. What percentage chose A?

    $\frac{36}{150} \times 100\% = 24\%$.

16. What is a 'share' of a total, expressed from table data?

    The proportion one category contributes to the whole, $\frac{\text{part}}{\text{total}}$, usually given as a percentage or fraction; all shares of a complete table sum to $100\%$.

17. How do you find what value corresponds to a given percentage of a table total?

    Multiply the total by the percentage as a decimal: $\text{value} = T \times \frac{p}{100}$. For example, $15\%$ of $2{,}400$ is $2{,}400 \times 0.15 = 360$.

18. What is the formula for the (arithmetic) mean of $n$ tabulated values?

    $$\bar{x} = \frac{\sum_{i=1}^{n} x_i}{n} = \frac{\text{sum of values}}{\text{number of values}}$$

See more Data Interpretation: Tables flashcards →

Planning Data Interpretation: Tables for Civil Service Numerical Reasoning Test

Data Interpretation: Tables (Civil Service Numerical Reasoning Test) FAQ