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
- Compute and read box plots with outliers
- Draw scatter plots and fit trend lines
- Aggregate, rank and share data for charts
Lessons
- 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
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
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
- Data Visualization: Quartiles by interpolationEasy
- Data Visualization: Fences, whiskers and outliersMedium
- Data Visualization: Draw a box plot as textHard
- Data Visualization: The correlation coefficientEasy
- Data Visualization: A scatter plot with overplotting countsMedium
- Data Visualization: Fit a trend lineHard
- Data Visualization: Totals per categoryEasy
- Data Visualization: Top N and OtherMedium
- Data Visualization: Percentages that add up to 100Hard