Microsoft Office Tutorials and References

In Depth Information

**Deviating from the Middle**

Figure 9-11:

Measuring

the kurtosis

of two

distributions.

This is how to use the KURT function:

1. Enter a list of numerical values.

2. Position the cursor in the cell where you want kurtosis to appear.

3. Enter
=KURT(
to start the function.

4. Drag the pointer over the list, or enter the address of the range.

5. Enter a
)
and press the Enter key.

Comparing data sets

At times you need to compare two sets of data to see how they relate to one

another. For example, how does the amount of snowfall affect the number of

customers entering a store? Does the money spent on advertising increase

the number of new customers? You answer these questions by determining

whether the two data sets are correlated.

Excel provides two functions for this task: COVARIANCE.S (or COVARIANCE.P)

and CORREL. Respectively, these return the
covariance
and
correlation

coefficient results from comparing two sets of data.

COVARIANCE.S and COVARIANCE.P

Either COVARIANCE function takes two arrays as its arguments and returns

a single value. The value can be positive or negative. A positive value means

that the two arrays of data tend to move in the same direction: If data set A