From data to report in one minute or less. Ajelix BI is launched! đźš€ Get started for free.

# How To Use 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.

Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

### 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.

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES

### Our Brands

#### Business Intelligence platform meets AI

Trusted by 150'000 customers around the globe since 2018.

Â© 2018 - 2024 AJELIX, SIA