# 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).

Now we apply the `SKEW.P`

function to the `age` column to calculate its skewness:

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