Calculate Kurtosis in Excel

Your goal

You need to calculate the kurtosis of univariate data Y1, Y2, …, YN.

Step-by-step tutorial

Excel has the KURT function for (excess) kurtosis.

Let's use the Titanic dataset, which contains the list of passengers for the ill-fated voyage. We'll measure the kurtosis 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 KURT function to the age column to calculate its kurtosis:

KURT function
KURT function

The result is 0.1510.

Kurtosis result and histogram
Kurtosis result and histogram