Calculate Skewness in Excel

Your goal

You need to calculate the skewness of a dataset in Excel.

Step-by-step tutorial

Excel supports two different functions for skewness: SKEW.P for populations, and SKEW for samples. The syntax is the same for both, so we'll focus on SKEW.P.

Let's use the Titanic dataset, which contains the list of passengers for the ill-fated voyage. We'll measure the skewness of the age variable.

First we use Excel's Filter feature (Data > Filter) to filter out values where the age is unknown (i.e., filter out the ? entries).

Filtering out bad data
Filtering out bad data

Now we apply the SKEW.P function to the age column to calculate its skewness:

SKEW.P function
SKEW.P function

The result is 0.3939, which indicates that the tail goes off to the right. We can confirm this by looking at the histogram:

Skewness result and histogram
Skewness result and histogram