KURT function - The function returns the sharp coefficient of a dataset in Excel
The following article introduces you to the KURT function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the sharp coefficient of the dataset. Kurtosis indicates the sharp or flat characteristics of a dataset.
- If the positive sharp coefficient -> is relatively pointed distribution.
- If the negative coefficient is negative -> the distribution is relatively flat.
Syntax: KURT (number1, [number2], .)
Inside:
- number1, [number2], .) : Arguments that you want to calculate the coefficient of sharpness, where number1 is the required value, the remaining arguments are optional and contain up to 255 number arguments .
Attention:
- The value of the argument must be a number, name, array or reference containing numbers.
- Logical or text values when typing directly into the argument list -> these values are still counted.
- If the argument is a reference array containing text values or logic -> these values are ignored, but the value 0 is still counted.
- Arguments that are text or error values cannot be converted -> cause errors in the function.
- If the number of data points is less than 4 or the standard deviation is 0 -> the function returns the # DIV / 0 error value
- The kurtosis is determined by the formula:
[left {{frac {{nleft ({n + 1} right)}} {{left ({n - 1} right) left ({n - 2} right) left ({n - 3} right)}} sum {{{left ({frac {{{x_i} - bar x}} {s}} right)} ^ 4}}} right} - frac {{3 {{left ({n - 1} right)} ^ 2 }}} {{left ({n - 2} right) left ({n - 3} right)}}]
Where: s is the sample standard deviation.
For example:
Find the sharp coefficient of the data set in the data table below:
- In the cell to calculate enter the formula : = KURT (D6: D10)
- Press Enter -> the sharp coefficient of the dataset is:
The kurtosis of the above data set is less than 0 -> this data set is distributed flat.
- Where the number of data points of 2 different x and y arrays is logical or text values -> the function ignores these values.
- If the score of the dataset is less than 4 -> the function returns the # DIV / 0 error value
Above are instructions and some specific examples when using the KURT function in Excel.
Good luck!
You should read it
- QUARTILE function - The function returns the quartile of a dataset in Excel
- PEARSON function - The function returns the Pearson product moment correlation coefficient in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
- CORREL function - The function returns the correlation coefficient between two data sets in Excel
- LARGE function - The function returns the kth largest value in a dataset in Excel
- TRIMMEAN function - The function returns the average of the inner part of a dataset in Excel
- QUARTILE.INC function - The function returns the quartile of a dataset including values 0 and 1 in Excel
- PERCENTRANK.INC function - The function returns the rank of a value in a dataset as a percentage including values 0 and 1 in Excel
- PERCENTRANK.EXC function - The function returns the rank of a value in a dataset as a percentage excluding values 0 and 1 in Excel
- FISHER function - The function returns the Fissher transformation at x in Excel
- RSQ - The function returns the square of the Pearson torque correlation coefficient in Excel
- SMALL function - The function returns the kth smallest value in a dataset in Excel
Maybe you are interested
How to increase or decrease laptop screen brightness Win 11/10/8/7
How to delete white space in a table in Word - Appears right below the data
Lost Admin rights on Windows 10, this is how to fix it
Tips for using emoji right in Chrome browser
Fix right-click issue on Windows 10
Invite to play the super exciting 3D version of the dinosaur lost its life game right on the web