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