The University of Manchester · FACULTY OF ENVIRONMENTAL SCIENCE

EART60061 Chap.2 Measuring Variability and the Standard Deviation

- one subject, every graph, every model, every mark
6 Chapters4-page Bible
Our own words - no uploaded lecturer files
Updated for this semester
Chapter 2 of 10 · EART60061

Measuring Variability and the Standard Deviation

Measuring Variability starts from the problem that no measurement of a continuous variable is the true value, so its quality must be stated before it can mean anything. Using two years of student heights, the chapter moves from comparing the shapes of frequency distributions to a single number.

The range uses only two values; deviations from the mean cancel to zero; removing their sign and dividing by the number of values gives a fair, assumption-free measure of spread. Squaring the deviations instead, dividing by n minus 1 for a sample and taking the square root gives the standard deviation, the parameter that links spread to the normal distribution.

The chapter also covers the spreadsheet habits the exercises depend on: automatic calculation, the FREQUENCY array function, absolute references and the choice between sample and population functions. Throughout, the emphasis is on why each step is taken: the range ignores most of the data, signed deviations cancel, and the divisor standardises for sample size.

Understanding those reasons makes the later move from spread to probability straightforward.

In this chapter

What this chapter covers

  • 01

    Frequency distributions of two samples

  • 02

    Range and its weakness

  • 03

    Mean absolute deviation

  • 04

    Sample standard deviation and n minus 1

  • 05

    STDEV, STDEV.S and STDEVP in Excel

  • 06

    Standardising spread for datasets of different size

Worked example · free

Compare two measures of spread for conductivity readings

Q [5 marks]. Five conductivity readings from one stream are 212, 220, 205, 218 and 215 uS/cm. Find the mean, the mean absolute deviation and the sample standard deviation. Marks shown follow AskSia practice and are not an official allocation.
Two samples of 500 heights share a mean of 172 cm but have standard deviations of 11.5 and 5.8 cm; the narrow sample piles more students into the central classeTwo samples of 500 heights share a mean of 172 cm but have standard deviations of 11.5 and 5.8 cm; the narrow sample piles more students into the central classes, so its bars rise higher while both histograms contain the same total.150170190050100150Height class (cm)Students per classwide samplenarrow sample
Two samples of 500 heights share a mean of 172 cm but have standard deviations of 11.5 and 5.8 cm; the narrow sample piles more students into the central classes, so its bars rise higher while both histograms contain the same total.
  • 1Mean = 1,070 / 5 = 214 uS/cm; deviations are -2, 6, -9, 4 and 1, summing to zero.
  • 1Mean absolute deviation = (2 + 6 + 9 + 4 + 1) / 5 = 22 / 5 = 4.4 uS/cm.
  • 1Squared deviations are 4, 36, 81, 16 and 1, totalling 138.
  • 2Divide by n minus 1 = 4 to get 34.5, then take the square root: s = 5.87 uS/cm.
The mean is 214 uS/cm, the mean absolute deviation 4.4 uS/cm and the sample standard deviation 5.87 uS/cm. The standard deviation is larger because squaring weights the biggest deviation, -9, more heavily.
Sia tip — Use n minus 1 for replicate field or laboratory data; STDEV and STDEV.S do this, STDEVP does not.
Glossary

Key terms

Frequency distribution
A count of how many measurements fall into each class, used to compare the shape and spread of datasets.
Mean absolute deviation
The average distance of values from their mean, ignoring sign, which makes no assumption about how errors are distributed.
Absolute reference
A spreadsheet cell reference fixed with dollar signs so that it does not shift when a formula is copied.
Population standard deviation
The spread of a complete population, dividing by n rather than n minus 1, returned by STDEVP in Excel.
FAQ

Measuring Variability and the Standard Deviation FAQ

Why can a measurement never be the true value?

Any measurement of a continuous variable carries error from the instrument, the procedure and natural variation. The module therefore treats a result as meaningful only when it is quoted with an indication of its quality, which requires repeated measurements so that the variability can be quantified.

Why divide by n minus 1 in the standard deviation?

The values are usually a sample of a larger population, such as 500 students out of a whole university. Dividing by n minus 1 instead of n corrects for estimating the mean from the same sample, and it is what STDEV and STDEV.S do in Excel.

What is the FREQUENCY function used for?

It sorts a dataset into classes for a frequency distribution. It is an array function: highlight the output cells, enter the data range and the class limits as arguments in the formula bar, then press Control, Shift and Enter together so the counts fill every cell at once.

Should I use the range or the standard deviation to compare datasets?

The range is quick but uses only the largest and smallest values, so one unusual reading can change it completely. The standard deviation uses every value and connects to the normal distribution, which is why the module builds towards it and uses it for confidence limits.

Why does the standard deviation square the deviations?

Squaring removes the sign so deviations no longer cancel, and it gives the parameter that controls the width of the normal distribution. The sign-free mean deviation also removes the sign but makes no assumption about how errors are distributed, so it cannot be turned into a probability in the same way.

Study strategy

Exam move

Do the long calculation once on a small dataset with a calculator, then reproduce it in Excel with deviation, squared deviation and sum columns before checking against STDEV. Write down which divisor each function uses. Then open the heights workbook, confirm that calculation is automatic and practise an absolute reference by copying a deviation formula down a column and checking that it still points at the mean.

Once the calculation is secure, compare the two years of heights with both measures and explain in one sentence why they rank the years the same way.

A+Everything unlocked
Unlocks this Bible + all 41 of your subjects at The University of Manchester, plus 1,000+ more Bibles across the AskSia library.
Sia - your EART60061 tutor, unlimited, worked the way the exam marks it
The full 4-page Bible + practice bank with worked solutions
Chrome extension - sync your LMS so Sia knows your deadlines
Bilingual EN / Chinese on every Bible and every Sia answer
$0.99 Trial
30-day money-back · cancel in one tap · how it works