Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset. Learn more
In Google Sheets, the KURT() function is used to calculate the kurtosis of a dataset, which measures the "peakedness" or "flatness" of the distribution of values.
Kurtosis is a statistical measure that describes the shape of a probability distribution.
The KURT() function takes one required argument, value1, and an optional range of additional values (value2, value3, etc.) that represent the dataset you want to analyze.
Here's the syntax of the KURT() function:
KURT(value1, [value2, …])
value1: The first value or range of values representing the dataset for which you want to calculate kurtosis.
value2, value3, …: Optional additional values or ranges representing the dataset.
The KURT() function returns the kurtosis value of the provided dataset. A positive kurtosis value indicates a peaked distribution, while a negative kurtosis value indicates a flat distribution.
A kurtosis value of 0 indicates a normal distribution.
It's important to note that the KURT() function in Google Sheets calculates the sample kurtosis, not the population kurtosis. If you want to calculate the population kurtosis, you can use the KURT.P() function instead.
Example usage:
=KURT(A1:A10) // Calculates the kurtosis of values in the range A1 to A10.
Remember to adjust the cell references and range to match your specific dataset.