From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

# KURT function in Excel Explained

### What is KURT Function in Excel?

The KURT function in Excel returns the kurtosis of a data set, which measures the peakedness of the data values relative to a normal distribution. Kurtosis can be used to detect outliers in a data set.

### Description

Kurt Function MS Excel is a statistical tool used to measure a data set’s tail weight. The tail weight of a data set describes the degree to which its distribution is more or less peaked than a normal distribution. The function can be used to analyze the distribution of data in a range of cells and to determine if the data is skewed or has outliers.

The KURT formula takes four arguments: the range of cells containing the data, the number of observations, the number of variables, and the mean of the data set. The function will then return a value between -3 and +3, which indicates the degree to which the data distribution is more or less peaked than a normal distribution.

A value closer to -3 indicates that the data is more platykurtic or less peaked and indicates a distribution with more extreme values.

A value closer to +3 indicates that the data is more leptokurtic, or more peaked, and is indicative of a data set with fewer extreme values.

Kurt function can help you identify outliers and skewness. It can be used to gain insight into the underlying structure of a data set and compare data sets to each other. Function can identify the most important variables in a data set and identify relationships between variables.

### KURT Function Syntax

KURT(number1, [number2], …)

number1: A numeric value or range of values.

[number2], …: Optional additional numeric values or ranges of values. ### How to use KURT function MS Excel in your workbook:

1. Open the Microsoft Excel program on your computer.
2. Input the data that you want to use to calculate the Kurt function in the spreadsheet.
3. Click on the “Formulas” tab and then select “More Functions” from the ribbon.
4. In the “Select a Function” drop-down menu, select “Kurt”.
5. A dialog box will appear. In the “Number1” field, select the cell that contains the data that you want to use.
6. Click “OK” and the function will be calculated for that range of data.
7. To view the result, select the cell where you input the Kurt function and a value will be displayed.

### Similar Formulas

Does Excel report kurtosis or excess kurtosis?

Excel can report kurtosis, but not excess kurtosis.

What does kurtosis tell us?
Kurtosis is a measure of the “peakedness” of a distribution. It is a measure of the concentration of values at the center of the distribution. Higher kurtosis indicates higher concentration of values at the center with fewer values at the tails, thus creating a more peaked distribution. Low kurtosis indicates fewer values at the center and more at the tails, creating a flatter distribution.