# Descriptive Statistics and Summarizing Data

> Chapter 8 of the Courseiva DATA-PLUS curriculum — https://courseiva.com/learn/data-plus/descriptive-statistics-and-summarizing-data

**Official objective:** 3.1 — Calculate descriptive statistics and summarize data

## Introduction

Before we talk about descriptive statistics and summarising data, this chapter sits squarely inside Domain 3.0 of the DA0-002 exam, which is all about analysing and presenting data. If you have ever looked at a spreadsheet full of numbers and felt overwhelmed, this concept is your rescue — it turns a chaotic cloud of raw facts into clear, decision-ready insight.

## The Kitchen Prep Log Analogy

Ever stood in a kitchen and wondered if you have enough ingredients to feed ten guests for dinner?

You start by pulling out your recipe book, your shopping receipt, and a notebook. First, you count every single item: 4 onions, 3 bell peppers, 2kg of chicken, 6 tomatoes. That raw list is your data set — just facts with no meaning yet. Then you begin noticing patterns: most recipes call for onions, so onions appear most often — that is the mode. The average cost per meal? You add up all the prices and divide by the number of recipes — that is the mean. The middle-priced recipe when you line them up from cheapest to most expensive? That is the median. You also want to see the spread: the cheapest recipe costs £5 and the most expensive costs £20, a range of £15. Now, instead of flipping through every receipt, you can say: "I have 10 recipes, the typical meal costs about £12, onions are in 70 per cent of them, and prices vary by about £15." That summary helps you decide whether to shop for more chicken or skip the fancy cheese. Exactly the same way, descriptive statistics take a huge pile of raw data and condense it into a handful of numbers that tell the story at a glance.

## Core explanation

Descriptive statistics are numbers that summarise and describe the main features of a data set without trying to infer anything beyond that data. They are the foundation of data analysis because they give you a quick, honest snapshot of what is actually going on.

There are two main categories: measures of central tendency and measures of dispersion (also called variability). Central tendency tells you where the centre of your data lies. Dispersion tells you how spread out your data is.

**Measures of Central Tendency**

- **Mean**: This is the arithmetic average. You add up every value in your data set and divide by the number of values. For example, if five employees have salaries of £30,000, £35,000, £40,000, £45,000, and £100,000, the mean is £50,000. But notice that one very high salary pulled the average up — the mean is sensitive to outliers (extreme values).
- **Median**: This is the middle value when you arrange the data in order from smallest to largest. In the same salary example, the middle value is £40,000. The median is much more resistant to outliers, so it often gives a better sense of a "typical" value when your data has extreme numbers.
- **Mode**: This is the value that appears most frequently. If you survey 50 people and 20 of them say their favourite colour is blue, then blue is the mode. You can have one mode, multiple modes, or no mode at all if every value appears exactly once.

**Measures of Dispersion**

- **Range**: The simplest measure. You subtract the smallest value from the largest value. In the salary example, range is £100,000 - £30,000 = £70,000. It gives a quick sense of spread but ignores everything in between.
- **Variance**: This measures how far each value in the data set is from the mean. You calculate the average of the squared differences from the mean. A high variance means the data points are far from the mean and from each other. A low variance means they cluster tightly.
- **Standard deviation**: This is the square root of the variance. It is expressed in the same units as the original data, which makes it easier to interpret. A small standard deviation (for example, 2 inches in a set of adult heights) means most values are close to the mean. A large standard deviation (say, 20 years in a group of ages that includes toddlers and grandparents) means the data is very spread out.

**Percentiles and Quartiles**

Percentiles divide your data into 100 equal parts. The 50th percentile is the same as the median. Quartiles divide your data into four equal parts. Q1 is the 25th percentile, Q2 is the median, and Q3 is the 75th percentile. The interquartile range (IQR) is Q3 minus Q1 and measures the spread of the middle 50 per cent of your data. The IQR is another outlier-resistant measure.

**Frequency Distributions**

A frequency distribution is a table that shows how often each value (or range of values) occurs. For example, a customer age data set might show that 10 customers are aged 18-25, 25 customers are aged 26-35, and so on. This gives you an immediate visual of where most of your data lives.

**Why These Statistics Exist**

Before formal statistics, people made decisions based on gut feeling or the most recent data point they remembered. Descriptive statistics replace guesswork with standardised, repeatable methods. They allow you to communicate complex data to stakeholders in a few numbers — the average, the spread, the most common value. The DA0-002 exam expects you to calculate these by hand in some questions, and also to interpret what they mean in a business context.

## Real-world context

A retail manager at a clothing chain named Stitch & Co. needs to decide how many units of a new jacket to order for next winter. She has last year's sales data for 120 stores.

She pulls the data into a spreadsheet. The raw data is just a column of numbers: 45, 62, 38, 101, 77, 54, and so on — 120 numbers that mean nothing by themselves.

She starts with descriptive statistics. First, she calculates the mean: total jackets sold across all stores divided by 120 stores comes to 62 jackets per store. That is the average. But she knows that one flagship store in London sold 320 jackets, which is unusually high. She checks the median: when she sorts all 120 numbers, the middle two values are 58 and 61, so the median is 59.5 jackets. That number — 60 jackets — feels more realistic for a typical store.

She then calculates the mode. Looking at the frequency distribution, the most common sales number is 54 jackets — 12 stores sold exactly that many. The mode tells her what the most likely scenario is.

Next, she measures spread. The range is 320 - 20 = 300 jackets, which is huge and not very helpful because of that one flagship outlier. She calculates Q1 (42 jackets) and Q3 (78 jackets), so the interquartile range is 36 jackets. That tells her that the middle 50 per cent of stores sold between 42 and 78 jackets. Now she has a realistic picture: most stores will sell between 42 and 78 jackets, with a typical store selling about 60.

She also calculates the standard deviation, which comes out to 22 jackets. That means roughly 68 per cent of stores sold between 40 and 84 jackets (mean ± one standard deviation). She now has confidence intervals for her ordering decision.

Based on this summary, she orders 75 jackets for each of the 120 stores, but orders 200 for the flagship London store because it is a clear outlier that needs special treatment. The descriptive statistics turned a messy column of numbers into a clear, defensible business decision.

An IT professional supporting this manager would use tools like Python (with libraries such as pandas and numpy), R, Excel, or business intelligence tools like Tableau to automate these calculations. The exam tests whether you understand which statistic to use when, not necessarily how to code it.

## Exam focus

The DA0-002 exam tests descriptive statistics in several specific ways. Expect approximately 5 to 8 questions on this topic across the whole exam.

**Question Types**

- **Calculation questions**: You will be given a small data set (typically 5 to 10 numbers) and asked to calculate the mean, median, mode, or range. You must do this without a calculator in some cases — the exam allows a basic on-screen calculator, but practising mental math helps.
- **Interpretation questions**: The exam gives you the result of a descriptive statistic and asks what it means in context. For example, "The median salary for employees is £42,000. What does this tell you?" The correct answer is that half of employees earn less than £42,000 and half earn more.
- **Best choice questions**: You will be given a scenario and asked which measure of central tendency is most appropriate. For example, if the data has extreme outliers, the answer is almost always the median. If the data is perfectly symmetrical with no outliers, the mean is fine.
- **Effect of outliers**: A classic trap: the exam describes a data set with one extreme value and asks which measure is most affected. The answer is the mean. They also ask which measure is least affected — the median or mode.

**Traps to Watch For**

- They will give you a data set with an even number of values and ask for the median. Candidates often forget to take the average of the two middle numbers.
- They will describe a bimodal distribution (two modes) and ask what the mode is. Some candidates answer "one" — you need to list both values.
- They will conflate variance and standard deviation in distractor answers. Variance is the square of the standard deviation; the units differ.
- They will ask for the interquartile range and list the range as a distractor. Be precise: IQR is Q3 - Q1, not max - min.

**Concepts You Must Memorise**

- Mean = sum of values / number of values.
- Median = middle value (or average of two middle values) when sorted.
- Mode = most frequent value.
- Range = max - min.
- Interquartile range (IQR) = Q3 - Q1.
- Standard deviation = square root of variance.
- The mean is affected by outliers; the median is not.
- The IQR is resistant to outliers; the range is not.
- Frequency distribution shows count per value or bin.

## Step by step

1. **Collect and organise the raw data** — Gather all the data points relevant to your question. For the DA0-002 exam, you will typically be given a small list of numbers. Organise them in ascending order — this makes it much easier to find the median, range, and quartiles. This step mirrors what a data analyst does when they import a CSV file into Excel or pandas.
2. **Calculate measures of central tendency** — Compute the mean by summing all values and dividing by the count. Find the median by locating the middle value (or averaging the two middle values) in your sorted list. Determine the mode by counting which value appears most frequently. These three numbers give you different perspectives on where the centre of the data is.
3. **Calculate measures of dispersion** — Compute the range by subtracting the minimum from the maximum. Calculate variance by finding the average of squared deviations from the mean. Take the square root of variance to get standard deviation. Find Q1 and Q3 (the medians of the lower and upper halves of the data) and subtract Q1 from Q3 to get the IQR. Each measure tells you how spread out the data is in a different way.
4. **Build a frequency distribution** — Group the data into intervals (bins) or list each unique value and count how many times it occurs. For the exam, you might be asked to interpret a pre-built frequency table. In real life, this helps you spot patterns — like whether most customers spend less than £50 or whether sales are evenly distributed across all price points.
5. **Interpret the statistics in context** — Look at all the numbers together and decide what story they tell. Is the mean much higher than the median? That signals right-skewed data with high outliers. Is the standard deviation large relative to the mean? That tells you the data is highly variable. This final step is what the DA0-002 exam tests most — not just the calculation, but the business meaning behind the numbers.

## Comparisons

### Mean vs Median

**Mean:**
- Calculated by summing all values and dividing by the count
- Highly sensitive to outliers and skewed data
- Best used for symmetrical distributions without extreme values

**Median:**
- Calculated by finding the middle value in sorted data
- Resistant to outliers and skewed data
- Best used for skewed distributions or data with extreme values

### Range vs Interquartile Range (IQR)

**Range:**
- Max value minus min value
- Highly sensitive to a single outlier
- Uses only two data points, ignoring the rest

**Interquartile Range (IQR):**
- Third quartile (Q3) minus first quartile (Q1)
- Resistant to outliers — focuses on middle 50% of data
- Uses many data points and gives a more stable picture of spread

### Variance vs Standard Deviation

**Variance:**
- Average of squared deviations from the mean
- Measured in squared units of the original data
- Harder to interpret directly because of squared units

**Standard Deviation:**
- Square root of variance
- Measured in the same units as the original data
- Easier to interpret and commonly reported alongside the mean

### Mode vs Mean

**Mode:**
- The most frequently occurring value in the data set
- Can be used for both numerical and categorical data
- May not exist or may not be unique (multimodal)

**Mean:**
- The arithmetic average of all values
- Only meaningful for numerical data
- Always exists and is unique for a given data set

## Diagram

_A flowchart showing how raw data flows into two categories of descriptive statistics: central tendency (mean, median, mode) and dispersion (range, variance, standard deviation, IQR), with the key characteristic of outlier sensitivity highlighted._

```mermaid
flowchart TD
    A[Raw Data] --> B[Descriptive Statistics]
    B --> C[Central Tendency]
    B --> D[Dispersion]
    C --> E[Mean]
    C --> F[Median]
    C --> G[Mode]
    D --> H[Range]
    D --> I[Variance]
    D --> J[Standard Deviation]
    D --> K[Interquartile Range IQR]
    E --> L[Sensitive to Outliers]
    F --> M[Resistant to Outliers]
```

## Common misconceptions

- **Misconception:** The mean and the average are two different things. **Reality:** The mean is one specific type of average. There are multiple averages in statistics (mean, median, mode), but 'average' in everyday language usually refers to the mean. In DA0-002, they use 'average' to mean the mean unless stated otherwise. (Everyday language uses 'average' loosely, so beginners assume it is a separate concept from the mean, which creates confusion in exam questions that use both terms.)
- **Misconception:** If a data set has a high mean, the median must also be high. **Reality:** The mean and median can differ significantly, especially in skewed data. For example, in a set of incomes with a few very high earners, the mean will be higher than the median. They are independent measurements of centre. (Beginners intuitively think numbers that describe the same data must agree, but they do not realise outliers pull the mean while the median stays stable.)
- **Misconception:** Standard deviation and variance tell you exactly where every data point is located. **Reality:** Standard deviation and variance only tell you about the average spread of the data around the mean. They do not identify which specific data points are outliers or give you the exact position of any single value. (The terms sound precise and technical, so beginners assume they reveal more detail than they actually do. This leads to misinterpreting what these statistics mean in a business context.)
- **Misconception:** The mode is always the most useful measure of central tendency because it shows what happens most often. **Reality:** The mode is often the least useful measure, especially with continuous data (like heights or temperatures) where no value repeats exactly. It is most useful for categorical data (like favourite colours) or discrete data with few possible values. (In real-life examples, people often focus on what is 'most common' because it feels intuitive. But in many data sets, the mode provides very little information, and beginners overvalue it.)
- **Misconception:** The interquartile range (IQR) is just another name for the range. **Reality:** The IQR measures the spread of the middle 50 per cent of the data (Q3 minus Q1), while the range measures the total spread from minimum to maximum. The IQR is resistant to outliers; the range is not. (Both terms contain the word 'range', so beginners often treat them as synonymous, leading to wrong answers on exam questions that ask for the IQR but list the range as a distractor.)

## Key takeaways

- Descriptive statistics summarise a data set using measures of central tendency (mean, median, mode) and measures of dispersion (range, variance, standard deviation, IQR).
- The mean is sensitive to outliers; the median is resistant to outliers — choose the median when your data has extreme values.
- Standard deviation is the square root of variance and is measured in the same units as the original data, making it easier to interpret than variance.
- The interquartile range (IQR) is the difference between the 75th and 25th percentiles and describes the spread of the middle 50 per cent of your data.
- Frequency distributions group data into intervals and show how often each interval occurs, giving you an immediate visual summary of the data's shape.
- On the DA0-002 exam, always sort your data before finding the median — and remember to average the two middle values when the data set has an even number of entries.
- Outliers affect the mean and range the most and affect the median and IQR the least — this is a frequent exam question trap.
- The mode is most useful for categorical or discrete data with a limited number of possible values, not for continuous data.
- Descriptive statistics describe only the data you have — they do not make predictions or inferences about a larger population (that is inferential statistics).

## FAQ

**Do I need to calculate standard deviation by hand on the DA0-002 exam?**

Yes, you could be asked to calculate or estimate standard deviation for a small data set. More commonly, you will be given two standard deviations and asked which one corresponds to a described data set. Understanding the concept — that a larger standard deviation means more spread — is more important than memorising the formula.

**What is the difference between descriptive statistics and inferential statistics?**

Descriptive statistics summarise and describe the data you have collected. Inferential statistics use that data to make predictions or generalisations about a larger population. For DA0-002, you only need to know descriptive statistics, but knowing the difference helps you avoid confusion.

**How do I know whether to use the mean or the median on an exam question?**

Look for clues about outliers or skewness. If the scenario mentions extremely high or low values, or if the data is described as 'skewed', choose the median. If the data is symmetrical, the mean is appropriate. The exam often explicitly says 'which measure is most affected by outliers' — the answer is always the mean.

**What does it mean when the mode is higher than the median?**

It means the most frequently occurring value is above the middle value, which could indicate the data is skewed or has a cluster of high values. In a unimodal symmetric distribution, the mean, median, and mode are roughly equal. Any significant difference between them signals a skew or outliers.

**Is the range a useful measure on its own?**

Not really, because it only uses two values (the minimum and maximum) and ignores everything in between. The IQR is much more useful because it focuses on the middle 50 per cent of data. However, the exam expects you to know how to calculate and interpret the range, and it sometimes appears in questions.

**What is a frequency distribution table and how is it different from a histogram?**

A frequency distribution table lists categories or intervals alongside their counts. A histogram is a bar chart that visualises the same frequency distribution. The table gives exact numbers; the chart gives a visual shape. Both are ways of summarising data. The exam tests both.

**If two data sets have the same mean but different standard deviations, what does that tell me?**

It tells you that the two data sets have the same average value, but one is more spread out (larger standard deviation) and the other is more tightly clustered around the mean (smaller standard deviation). This is a common exam scenario — they will ask which data set is more 'variable' or 'consistent'.

## Check your understanding

1. **A data set contains the following numbers: 5, 7, 8, 12, 12, 15, 18. What is the mode?**

   Answer: The mode is 12, because it appears twice, more than any other value.

2. **If a data set has a very high outlier, which measure of central tendency is most affected: mean or median?**

   Answer: The mean is most affected. The median is resistant to outliers and changes very little.

3. **What is the interquartile range (IQR) and what does it measure?**

   Answer: The IQR is the difference between the third quartile (Q3) and the first quartile (Q1). It measures the spread of the middle 50 per cent of the data and is resistant to outliers.

4. **A dataset has a variance of 49. What is the standard deviation?**

   Answer: The standard deviation is 7, because the standard deviation is the square root of the variance.

5. **Why would a data analyst choose the median over the mean when reporting the typical income for a company's employees?**

   Answer: Because income data often has high outliers (executive salaries). The median is not affected by those outliers, so it gives a more accurate picture of what a typical employee earns.

---

Interactive version with quiz and diagrams: https://courseiva.com/learn/data-plus/descriptive-statistics-and-summarizing-data