Jump to navigation Jump to search
- Parameters are any numbers to calculate the skewness.
- SKEW() returns the skewness of a distribution
- This function gives the Skewness of a distribution.
- Skewness is a measure of the degree of asymmetry of a distribution.
- A distribution(normal distribution) is symmetry ,it don't have a Skewness.
- In a distribution the left tail is more pronounced than the right tail (towards more negative values) then the function is said to have Negative Skewness.
- If a distribution is skewed to the right, the tail on the curve's right-hand side is longer than the tail on the left-hand side (towards more positive values), then the function is said to have a positive skewness.
- In a Left Skewed Distribution, its
- In a Normal Skewed Distribution, its
- In a Right Skewed Distribution, its .
Where, is the sample standard deviation, represents a sample mean.
- This function will return the result as error when
1. Any one of the argument is non-numeric. 2. If there are fewer than three data points, or the Sample Standard Deviation is zero.
- =SKEW(B1:B5) = -0.4369344921493
- =SKEW(A1:A6) = -0.21921252920
- =SKEW(C1:C4) = -0.715957010
- =SKEW(D1:D6) = 0
- =SKEW(E1:E6) = 1.16584702768