Excel Cookbook by Dawn Griffiths

Author:Dawn Griffiths
Language: eng
Format: epub
Publisher: O'Reilly Media, Inc.
Published: 2023-02-07T00:00:00+00:00

Solution

Use the SKEW function.

Suppose you have a list of numbers and want to determine the dataset’s degree of asymmetry about the list’s mean. You can do so by calculating the skewness using the formula =SKEW(numbers). To determine the skewness of numbers listed in A2:A101, for example, you’d type =SKEW(A2:A101).

The skewness is a number whose value indicates the degree of asymmetry (see Figure 5-16):

If the skewness is close to 0, the data is reasonably symmetric about the mean.

If the skewness is less than -1, there’s a high degree of negative (or left) skew. There’s a long tail of low values on the left of the distribution.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.