Documentation/Calc Functions/SKEWP
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
SKEWP
Category:
Statistical Analysis
Summary:
Calculates the skewness of distribution using the population, i.e. the possible outcomes, of a random variable. Skewness is a measure of the asymmetry of a distribution about its mean.
Syntax:
SKEWP(Number 1 [; Number 2 [; … [; Number 255]]])
Returns:
Returns a real number which is the skewness of the distribution using a population of random variables of a specified sample of numbers.
Arguments:
Number 1, Number 2, ..., Number 255 are numbers, references to cells or to cell ranges of numbers.
- The parameters should specify at least three values. However, the function returns 0 for only three values.
- If there are less than three values, then the function will return a division (#DIV/0!) error.
- If any of the arguments contain text value either being passed directly then the function returns a name (#NAME?) error and if with double quotes then the function returns an error value (Err:504).
- If a cell contains text, error value, or empty cells, then the function ignores these values. However, for logical values TRUE is considered as 1 and FALSE as 0.
- If a cell contains 0 then the function includes it.
Additional details:
- Unlike SKEW, SKEWP uses the standard deviation of the entire population rather than an individual sample.
- The formula for SKEWP is:
where N is the count of data points, x̄ is the expectation value (mean of the specified set of numbers) and s is the standard deviation estimate (standard deviation of the specified set of numbers).
- For more details on skewness, visit Wikipedia.
Examples:
Formula | Description | Returns |
---|---|---|
=SKEWP(3;4;5;6;2;3;1) | The function calculates the skewness of the distribution using a population of the random variables. | 0.130358686954918 |
=SKEWP(A1:A5) where A1:A5 contains 1,2,3,4,5 | The function calculates the skewness of the distribution using a population, passed as a cell range, of the random variables. | 0 |
=SKEWP(3;4) | The function will return a division error since less than 3 values are specified. | #DIV/0! |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
SKEW.P