KURTOSIS
Overview
The KURTOSIS function computes the kurtosis (Fisher or Pearson) of a dataset. Kurtosis is a measure of the “tailedness” of the probability distribution of a real-valued random variable. This function flattens the input, ignores non-numeric values, and always omits NaN values (nan_policy is set to ‘omit’). Excel’s KURT function computes excess kurtosis (Fisher); this function allows both Fisher and Pearson forms. For more details, see the scipy.stats.kurtosis documentation .
This example function is provided as-is without any representation of accuracy.
Usage
To use the function in Excel:
=KURTOSIS(data, [fisher], [bias])data(2D list, required): Data to compute kurtosis for. Must have at least two numeric elements after flattening.fisher(bool, optional, default=True): If True, Fisher’s definition is used (normal ==> 0.0). If False, Pearson’s definition is used (normal ==> 3.0).bias(bool, optional, default=True): If False, then the calculations are corrected for statistical bias.
The function returns a single value (float): the kurtosis of the data, or an error message (string) if the input is invalid. NaN values are always omitted.
Examples
Live Notebook
Edit this function in a live notebook .