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
Search JabSto ::

Custom Search