Welcome to Handling Data: Tables, Charts, and Diagrams
Data is everywhere in the modern world, from your phone screen time to football match statistics and weather forecasts! In your CCEA GCSE Mathematics exam (Specification 2210), handling data is all about collecting information, organising it clearly, drawing neat diagrams, and making sense of what the numbers show.
Don't worry if maths charts have felt confusing in the past. We will break every single chart, table, and diagram down into simple, step-by-step instructions with clear examples and helpful tips to help you secure top marks across both Foundation and Higher tiers.
1. The Handling Data Cycle & Types of Data
Every statistical investigation follows a logical four-stage journey known as the Handling Data Cycle:
Stage 1: Specify the problem and plan
Decide what question you want to answer or what hypothesis you want to test. Choose what data you need, decide on a fair sample size, and plan how to avoid bias.
Stage 2: Collect data
Gather your information using questionnaires, data collection sheets, or tally charts. Make sure your questions are fair and not leading.
Stage 3: Process and represent data
Organise the raw numbers into frequency tables, calculate averages (mean, median, mode) and spread (range), and draw accurate graphs or diagrams.
Stage 4: Interpret and discuss
Look at your graphs and calculations to draw sensible conclusions. Relate your findings back to your original question, spot patterns or exceptions, and think about any limitations in your method.
Understanding Types of Data
Before you draw a chart, you need to know what type of data you have:
• Qualitative Data: Non-numerical data described using words or categories (e.g. favourite colour, car brand, eye colour).
• Quantitative Data: Numerical data that can be counted or measured.
– Discrete Data: Numerical values that can only take specific, distinct values with gaps in between, usually counted in whole numbers (e.g. number of siblings, shoe sizes, goals scored).
– Continuous Data: Numerical values that can take any value on a continuous scale and are measured (e.g. height in cm, time in seconds, mass in kg).
Key Takeaway: Always ask yourself: "Is it counted (discrete) or measured (continuous)?" This helps you choose the right diagram!
2. Tables and Data Listings
Two-Way Tables
A two-way table organises data involving two separate categorical variables (such as gender and favourite subject). Each cell shows the frequency for that specific pair of categories, and row and column totals must always add up correctly.
Example: A group of \(50\) students were asked whether they prefer Tea or Coffee.
• Total Boys = \(28\)
• Boys who prefer Tea = \(12\)
• Total students who prefer Coffee = \(23\)
Let's find the missing values step-by-step:
1. Boys who prefer Coffee: \(28 - 12 = 16\)
2. Girls who prefer Coffee: Total Coffee \(-\) Boys Coffee = \(23 - 16 = 7\)
3. Total Girls: Total Students \(-\) Total Boys = \(50 - 28 = 22\)
4. Girls who prefer Tea: Total Girls \(-\) Girls Coffee = \(22 - 7 = 15\)
5. Total Tea: \(12 + 15 = 27\)
Double check: \(27\text{ (Tea)} + 23\text{ (Coffee)} = 50\). The totals match!
Frequency Tables: Ungrouped Data
An ungrouped frequency table lists individual data values (\(x\)) alongside how often they occur (\(f\)).
• Total Frequency (\(\sum f\)): Add all numbers in the frequency column: \(n = \sum f\).
• Mode: The value (\(x\)) that has the highest frequency.
• Median Position: Found at position \(\frac{n+1}{2}\).
• Mean (\(\bar{x}\)): Multiply each value by its frequency to get an \(f \times x\) column, sum them up, and divide by the total frequency:
\(\bar{x} = \frac{\sum fx}{\sum f}\)
Grouped Frequency Tables
When you have large sets of continuous or spread-out discrete data, values are grouped into class intervals (e.g. \(10 \le t < 20\)). Because we do not know the exact values inside each group, we can only calculate an estimated mean using the midpoint (\(m\)) of each class interval.
Step-by-Step Method for Estimated Mean:
1. Find the midpoint (\(m\)) of each interval: \(\text{Midpoint} = \frac{\text{Lower limit} + \text{Upper limit}}{2}\)
2. Multiply each midpoint by its corresponding frequency: \(f \times m\)
3. Calculate the sum of these products: \(\sum (f \times m)\)
4. Divide by the total frequency (\(\sum f\)):
\(\text{Estimated Mean} = \frac{\sum (f \times m)}{\sum f}\)
• Modal Class: The class interval with the highest frequency.
• Median Class Interval: The interval containing the \(\frac{n+1}{2}\) (or \(\frac{n}{2}\)) value.
Frequency Trees
A frequency tree is a branching diagram used to break down a total frequency into distinct sub-categories. You start with the overall total at the root on the left and split into branches towards the right. The numbers on the branches splitting from any single node must always add up to the number in that node.
Venn Diagrams
A Venn diagram uses overlapping circles inside a universal set rectangle (\(\xi\)) to sort data and count frequencies.
• The overlapping region (intersection) represents items belonging to both sets.
• The region inside a circle but outside the overlap represents items belonging only to that set.
• The region outside the circles represents items belonging to neither set.
Check: The sum of all numbers inside every region of the Venn diagram must equal the total number of items in the universal set.
Key Takeaway: In grouped frequency tables, always use the midpoint to find the estimated mean, and always divide by the total frequency (\(\sum f\)), never by the number of rows!
3. Statistical Charts and Diagrams
Pictograms
A pictogram uses pictures or symbols to represent data frequencies.
• Key: Every pictogram must have a clear key stating the value of one full symbol (e.g. \(\Box = 4\text{ books}\)).
• Partial Symbols: For fractions of a quantity, draw proportional parts of the symbol (e.g. half a square represents \(2\) books, a quarter square represents \(1\) book).
Bar Charts
Bar charts display discrete or categorical data using bars of equal width.
• Single Bar Chart: Shows one category per bar. Bars must have equal widths and equal spaces/gaps between them.
• Dual (Comparative) Bar Chart: Places bars side-by-side in pairs (e.g. comparing Boys vs Girls across different sports) with a clear key.
• Composite (Component) Bar Chart: Stacks sub-categories into a single vertical bar showing both the overall total and the breakdown.
• Golden Rule for Bar Charts: The vertical frequency axis must always start at \(0\) with an even, linear scale, and both axes must be clearly labelled!
Pie Charts
A pie chart is a circular chart divided into sectors, where the angle of each sector is proportional to the frequency of that category.
Step-by-Step Method to Draw a Pie Chart:
1. Find the Total Frequency (\(N = \sum f\)).
2. Find the angle per unit of frequency: \(\frac{360^\circ}{N}\)
3. Calculate the angle for each sector:
\(\text{Sector Angle} = \frac{\text{Frequency}}{\text{Total Frequency}} \times 360^\circ\)
4. Check that all your calculated sector angles add up to exactly \(360^\circ\).
5. Use a sharp pencil, a ruler for straight radii, and a protractor to measure angles carefully from the centre. Label each sector clearly with its category name.
Line Graphs and Time Series
A time series graph is a line graph where time is plotted on the horizontal axis (e.g. months, years, days) and the measured variable is on the vertical axis.
• Plot points accurately with small crosses (\(\times\)).
• Join consecutive points using straight, ruled line segments.
• Line graphs help us spot trends (general long-term patterns, such as an upward trend or downward trend over time).
Key Takeaway: Pie charts always represent a full circle of \(360^\circ\). Calculate your multiplier by dividing \(360^\circ\) by the total frequency first!
4. Advanced Diagrams
Stem-and-Leaf Diagrams
A stem-and-leaf diagram displays numerical data ordered row-by-row while keeping every original data value visible.
How to Construct a Stem-and-Leaf Diagram:
1. Choose the stem and leaf: The "stem" represents the leading digits (e.g. tens), and the "leaf" represents the final digit (units). Leaves must always be single digits (0 to 9).
2. Draw an unordered diagram first: Place numbers into their stem rows to make sure no data point is missed.
3. Draw the ordered diagram: Rewrite each row with the leaves in strict ascending order (smallest to largest), keeping columns neatly aligned with equal spacing.
4. Always write a KEY: A stem-and-leaf diagram is incomplete without a key explaining how to read the numbers.
Example Key: \(2 \mid 5 = 25\text{ marks}\) or \(1 \mid 4 = 1.4\text{ kg}\).
Frequency Polygons
A frequency polygon is a line graph used to represent grouped continuous or discrete data.
Step-by-Step Method:
1. Calculate the midpoint of each class interval.
2. Plot the midpoint on the horizontal axis (\(x\)) against the frequency on the vertical axis (\(y\)).
3. Join consecutive plotted points using straight ruled lines.
• Crucial Exam Rule: Do not join the first point to \((0,0)\) or extend the line down to the horizontal axis unless there is an actual class interval with a midpoint of \(0\)!
Scatter Graphs & Correlation
A scatter graph plots pairs of numerical data (bivariate data) as points to investigate whether a relationship exists between two variables.
Types of Correlation:
• Positive Correlation: As one variable increases, the other variable increases (points slope upwards from left to right, e.g. revision hours and exam marks).
• Negative Correlation: As one variable increases, the other variable decreases (points slope downwards from left to right, e.g. car age and value).
• Zero / No Correlation: No visible pattern or relationship between the points (points are scattered randomly, e.g. shoe size and maths score).
Line of Best Fit & Making Predictions
A Line of Best Fit is a single, straight line drawn with a ruler through the middle of the plotted points showing the general linear trend.
• It should follow the direction of the points, have a roughly equal balance of points above and below the line, and pass close to the mean point \((\bar{x}, \bar{y})\).
• Interpolation: Making a prediction within the range of the given data values. This is generally reliable and accurate.
• Extrapolation: Extending the line of best fit to predict values outside the collected data range. This is often unreliable and risky because trends may change.
Key Takeaway: Plot frequency polygons at class midpoints and connect with straight lines. For scatter graphs, always use a ruler to draw a balanced line of best fit.
5. Summary: Common Pitfalls & Top Tips to Ace Your Exam
Avoid these common examiner-reported mistakes to ensure you get full marks:
1. The Forgotten Key: Always write a key for pictograms, dual bar charts, and especially stem-and-leaf diagrams. Without a key, you lose an easy communication mark!
2. Frequency Polygon Points: Never plot frequencies at the upper or lower class boundaries. Always plot at the midpoint and use straight lines (never curves).
3. Estimated Mean Division: Always divide \(\sum (f \times m)\) by the total frequency \(\sum f\), never by the number of class rows in the table.
4. Bar Chart Spacing: For discrete bar charts, leave equal gaps between bars and ensure the vertical frequency scale starts strictly at \(0\).
5. Pie Chart Proportions: Double-check your sector angle formula: \(\frac{\text{Frequency}}{\text{Total Frequency}} \times 360^\circ\). Ensure your angles sum to \(360^\circ\).
6. Two-Way Table Checks: Always cross-check that your row totals and column totals match up to the same grand total in the bottom-right corner.