Microsoft Office Tutorials and References
In Depth Information
KURT
Figure 11.22
Use the Chart Wizard to
plot the known values
on a line chart.
KUR KURT returns the Kurtosis of a data set.
=KURT(number1,number2,...)
Kurtosis characterizes the relative peakedness or flatness of a distribution compared to the
normal distribution. When the Kurtosis is positive, the distribution is relatively peaked. When
the Kurtosis is negative, the distribution is relatively flat.
The arguments (up to 30 argument), including cell references, range
names, or arrays. More than four data points are required for the KURT
function to calculate a result.
NUMBER N
The calculation KURT(1,3,7,2,3,9,2,4) returns 0.384769378 and KURT (2,4,3,5,1,2,3,4)
returns –0.7. The equation for KURT is
LARGE
LARGE returns the k-th largest value in a data set.
=LARGE(array,k)
The LARGE function is used to retrieve a value based on its standing or rank in the data set.
Figure 11.23 shows an example of the LARGE function returning the third largest number from
the list.
Is the range of data from which you want to return the k-th largest value.
ARRAY
Is the position (from the largest) of the data point you want to return.
K
Search JabSto ::




Custom Search