Distributions, relationships and aggregation

Box plots for comparing distributions, scatter plots with trend lines for relationships, and aggregating raw records into chart-ready totals.

About 6 hours of study

Learning objectives

Lessons

  1. 1

    Box plots and quartiles Intermediate

    Summarising a distribution in five numbers: quartiles by linear interpolation, the interquartile range, Tukey's fences for outliers, whiskers, and comparing groups with box plots side by side.

  2. 2

    Scatter plots and correlation Intermediate

    Showing the relationship between two numerical variables: mapping points to a grid, overplotting, the correlation coefficient, a least-squares trend line, and why correlation is not causation.

  3. 3

    Aggregating data for charts Intermediate

    Charts rarely show raw rows: grouping and summing by category, sorting, keeping the top N and folding the rest into Other, rounding percentages so they add up to 100, and pivot tables for two categories at once.

Module practice

Module quiz

1. What does the box in a box plot span?
2. What does a trend line on a scatter plot summarise?
3. Why fold small categories into Other?
4. With Q1 = 10 and Q3 = 20, which value is an outlier by the 1.5 × IQR rule?
5. Many points overlap on a scatter plot. A good fix is…
6. Why use the largest remainder method for percentage labels?

‹ Core chartsDesign and honesty ›