SKEW

SKEW(number1 [,number2] [..])

Returns the number representing the skewness of a distribution based on a sample.

number1The first number.
number2(Optional) The second number.

REMARKS
* The Skewness of a Probability Distribution is a measure of asymmetry about its mean.
* Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.
* Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.
* You can also use a single array or a reference to an array instead of arguments separated by commas.
* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If there are fewer than three data points, or the sample standard deviation is zero, then #DIV/0! is returned.
* You can have a maximum of 255 arguments.
* You can use the KURT function to return the kurtosis for a probability distribution based on a sample.
* You can use the SKEW.P function to return the skewness for a probability distribution based on an entire population.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=SKEW(3, 4, 5, 2, 3, 4, 5, 6, 4, 7) = 0.360


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top