Advanced Excel Statistical - SKEW.P Function

Description

The SKEW.P function returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

SKEW.P uses the following equation −

$$v=\frac{1}{N}\sum_{i=1}^{N} \square \frac{x_i-x^{-3}}{\sigma }$$

Syntax

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

Arguments

Argument Description Required/ Optional
Number 1 Number 1, number 2… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness. Required
Number 2... Optional

Notes

  • 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.

Applicability

Excel 2013, Excel 2016

Example

Skew.P Function
advanced_excel_statistical_functions.htm
Advertisements