Calculate Skewness in Excel
You need to calculate the skewness of a dataset in Excel.
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
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
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: