September 23, 2023

How to use SKEW.P Function in Excel

Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

Syntax:= SKEW.P(number 1, [number 2],…)

The SKEW.P function syntax has the following arguments:

  • Number 1, number 2,…    Number 1 is required, subsequent numbers are optional. Number 1, number 2,… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness.

    SKEW.P uses the following equation:
    SKEW.P Function in Excel - How to use SKEW.P Function in Excel

Example: Let’s look at some Excel SKEW.P function examples and explore how to use the SKEW.P function as a worksheet function in Microsoft Excel:

Example of SKEW.P Function in Excel (Positively Skewed in Excel):

Column A has a distribution of values. Skewness these values can be calculated using formula

Syntax:  =SKEW.P(A2:A21)

Result: 0.457584052

SKEW.P Function in Excel - How to use SKEW.P Function in Excel

as shown in the above example. This result in the value of 0.457584052. Which indicates positive skew.

Example of SKEW.P Function in Excel (Negatively Skewed in Excel):

Column A has a distribution of values. Skewness these values can be calculated using formula

Syntax:  =SKEW.P(A2:A21)

Result: -0.714243489

SKEW.P Function - How to use SKEW.P Function in Excel

as shown in the above example. This result in the value of -0.714243489 which indicates negative skew.

Note:

  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.
  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero (0) are included,
  • SKEW.P uses the standard deviation of an entire population, not a sample.
  • If arguments are values that are not valid, SKEW.P returns the #NUM! error value.
  • If arguments use data types that are not valid, SKEW.P returns the #VALUE! error value.
  • If there are fewer than three data points, or the sample standard deviation is zero, SKEW.P returns the #DIV/0! Error value.
READ:  How to use FORECAST.ETS.SEASONALITY Function in Excel

 

Leave a Reply

Your email address will not be published. Required fields are marked *