Skip main navigation


Next, I want to talk about skewness, which is a handy way to quickly summarise the shape of a distribution or, in other words, what your scores tend to be doing. Here I’ve got three histograms on the screen. Now if you look in the middle, you see one that looks symmetrical. We say this has no skew. It looks like a bell curve. The bulk of the scores are right in the middle. So we say that has no skew. But look at the one to the left. The bulk of the squares have shifted off to the side a little bit, and there’s a long tail going off to the right. We say this is positive skew. Why positive skew?
Because the long tail is going in the positive direction. If I know a variable has a positive skew, it tells me most scores tend to be at the low end, but there’s a small number of people that trail off in the positive direction. So just by knowing a variable has a positive skew, I now have that information. Most scores tend to be at the low end. A large number of people trail off in the positive direction. So it’s a useful thing to know about a variable, just by knowing the skew. I can also go the other way. Look at the graph on the right.
Here we have the bulk of the scores on the right of the distribution, or at the upper end. And they trail off in the negative direction. So we say that is negative skew, a very handy way to describe the shape of a variable, and therefore know about what that variable is doing. Now briefly, I have something where I can quantify the skewness and it’s called the skewness statistic, or sk. It’s very intuitive. If there’s no skew, it’s symmetrical. Skew is zero. If there’s positive skew, or negative skew, the number is positive or negative. So if I’ve got negative skew, I’m going to have a negative number, a positive skew, a positive number.
You’ll get a chance to play with this in the labs. And you can see how different skewness levels translate into different numbers. But it is a handy way to summarise what your variable is doing. [LOGO MUSIC PLAYING]

Lesson 2: Skew

In the second lesson of this module, we’ll look at a new concept called “skewness,” which measures how asymmetrical (or skewed) a set of data is. We’ll also explore how to calculate skewness in Excel.

Lab: Skew

“Skewness” is all about how asymmetrical the distribution of a set of data is. In this lab, we’ll find out exactly how skewed the coffee variables from the previous lab are.

The lab instructions can be downloaded as a PDF file here.

The data set for this lab can be viewed here. From the link, copy and paste all the data into a new worksheet in Excel Online.

This article is from the free online

Essential Mathematics for Data Analysis in Microsoft 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