Skip main navigation

Measures of Spread – Range, Variance and Standard Deviation

Variance and standard deviation are two common measures of spread. Adrian discuss how they are calculated in this video.

Measures of Spread

Variance and standard deviation are the most common measures of how spread out data is.

While the range of the data is also a measure of spread, it ignores a lot of important information we normally want to capture. From this video, you should understand the relation between standard deviation and variance as well as how we calculate them.

Discuss with your fellow learners any questions you may still have in the comments below.

In the next step, we’ll talk about how we can use and interpret our measure of spread once we have calculated it.

This article is from the free online

Data Analytics for Decision Making: An Introduction to Using Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education