Frequency table or grouped data Revision Notes for Edexcel GCSE Statistics

Frequency table or grouped data

Understanding standard deviation with frequency tables

When working with frequency tables, calculating standard deviation requires a different approach compared to individual data values. You need to account for how many times each value appears in your dataset, which is where the frequency comes in.

The standard deviation measures how spread out your data points are from the mean. With frequency tables, some values appear more often than others, so we must weight each value by its frequency when performing calculations.

infoNote

The key difference when working with frequency tables is that we must consider how often each value occurs, not just the values themselves. This weighting by frequency is what makes the calculation different from working with individual data points.

The two formulas for standard deviation

There are two equivalent formulas you can use to calculate standard deviation from frequency tables:

Formula 1 (Definition formula): $\text{Standard deviation} = \sqrt{\frac{\Sigma f(x - \bar{x})^2}{\Sigma f}}$

Formula 2 (Computational formula): $\text{Standard deviation} = \sqrt{\frac{\Sigma fx^2}{\Sigma f} - \left(\frac{\Sigma fx}{\Sigma f}\right)^2}$

Both formulas will give you exactly the same answer. The second formula is often quicker to use because you don't need to calculate $(x - \bar{x})^2$ for each value.

chatImportant

Critical Exam Information: These formulas are NOT provided on your exam formula sheet, so you need to memorise them!

Key components you need to understand

Before diving into calculations, make sure you understand these essential parts:

f = the frequency (how often each value appears)
x = the data values
Σf = the total frequency (sum of all frequencies), which equals n
fx = frequency multiplied by the corresponding x-value
x̄ = the mean, calculated as $\frac{\Sigma fx}{\Sigma f}$

Step-by-step method for calculating standard deviation

Step 1: Set up your frequency table with additional columns for fx, (x - x̄), (x - x̄)², and f(x - x̄)²

Step 2: Calculate the mean using $\bar{x} = \frac{\Sigma fx}{\Sigma f}$

Step 3: For each row, work out (x - x̄)² and then f(x - x̄)²

Step 4: Find Σf(x - x̄)² by adding up all the f(x - x̄)² values

Step 5: Apply the formula: $\text{Standard deviation} = \sqrt{\frac{\Sigma f(x - \bar{x})^2}{\Sigma f}}$

Worked example: Football goals

Let's work through a complete example step by step to demonstrate the entire process.

lightbulbExample

Worked Example: Football Team Goal Statistics

A football team's goal-scoring record over 25 games is shown below:

Number of goals (x)	Frequency (f)	fx	x - x̄	(x - x̄)²	f(x - x̄)²
0	2	0	-1.8	3.24	6.48
1	8	8	-0.8	0.64	5.12
2	9	18	0.2	0.04	0.36
3	5	15	1.2	1.44	7.2
4	1	4	2.2	4.84	4.84
Totals	25	45	-	-	24

Step 1: Calculate the mean $\bar{x} = \frac{\Sigma fx}{\Sigma f} = \frac{45}{25} = 1.8$ goals per game

Step 2: Calculate $(x - \bar{x})$ for each value For example, when $x = 0$ : $x - \bar{x} = 0 - 1.8 = -1.8$

Step 3: Calculate $(x - \bar{x})^2$ for each value For example, when $x - \bar{x} = -1.8$ : $(-1.8)^2 = 3.24$

Step 4: Calculate $f(x - \bar{x})^2$ for each row For example, for the first row: $f(x - \bar{x})^2 = 2 \times 3.24 = 6.48$

Step 5: Find $\Sigma f(x - \bar{x})^2 = 24$

Step 6: Apply the formula $\text{Standard deviation} = \sqrt{\frac{24}{25}} = \sqrt{0.96} = 0.98$ goals (to 3 significant figures)

Alternative approach using the computational formula

You can also use the second formula, which sometimes involves less calculation and can be more efficient for larger datasets.

lightbulbExample

Alternative Method: Using the Computational Formula

Using the same football data, we need an additional column for $fx^2$ :

x	f	fx	fx²
0	2	0	0
1	8	8	8
2	9	18	36
3	5	15	45
4	1	4	16
Totals	25	45	105

Applying the computational formula: $\text{Standard deviation} = \sqrt{\frac{\Sigma fx^2}{\Sigma f} - \left(\frac{\Sigma fx}{\Sigma f}\right)^2}$

$= \sqrt{\frac{105}{25} - \left(\frac{45}{25}\right)^2} = \sqrt{4.2 - 3.24} = \sqrt{0.96} = 0.98$

This gives the same answer, confirming our calculation is correct.

Common exam mistakes to avoid

Students often make several predictable errors when working with frequency tables and standard deviation calculations.

chatImportant

Critical Mistakes to Avoid:

Forgetting to use frequencies: Don't just treat this like individual data values - you must multiply by the frequency each time.
Mixing up Σfx and Σx: Remember that when you have frequency tables, you use Σfx to find totals, not just Σx.
Incorrect mean calculation: The mean is Σfx/Σf, not just the average of the x-values.
Arithmetic errors: Always double-check your calculations, especially when squaring negative numbers.
Units: Don't forget to include appropriate units in your final answer.

Exam technique tips

Developing good exam technique is crucial for maximising your marks and avoiding unnecessary errors.

infoNote

Essential Exam Strategies:

Always show your working clearly by setting up a table with appropriate columns
Calculate the mean first and show this calculation explicitly
Round your final answer sensibly (usually to 3 significant figures unless told otherwise)
Check that your total frequency Σf matches what's given in the question
If using the computational formula, show the substitution into the formula clearly
Label all columns in your tables clearly
Show each step of your calculation process

bookmarkSummary

Key Points to Remember:

Standard deviation formulas for frequency tables are not on the exam formula sheet - you must memorise them
Both formulas give the same answer, so choose the one you find easier to work with
Always calculate the mean first: $\bar{x} = \frac{\Sigma fx}{\Sigma f}$
Set up clear tables with appropriate column headings to organise your work
Standard deviation measures the spread of data - a larger value means more variation from the mean
The key difference from individual data is the need to weight by frequency

Frequency table or grouped data (Edexcel GCSE Statistics): Revision Notes