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.


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.

KURT Function MS Excel - Ajelix Excel Formulas and Functions - Excel Formula Cheat Sheet

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.

Frequently Asked Questions

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.

Struggling with your Excel formulas?

Try out for free AI Excel Assistant who can generate Excel and Google Sheets formulas from your text. Explain your formulas and give descriptions to the most complicated formulas. Translate your Excel files in 28 lanugages. Write and explain your VBA and Google Apps Scripts. Register for free!

Start Generating Formulas

Struggling with your Excel formulas?

Check out our blog for the latest tips and tricks to help you become an expert. We have the insider scoop on the best strategies and resources to help you stay ahead of the curve. Click here to read our blog and start your journey towards Excel and Google Sheets mastery today!

Explore our blog