Investment Studio > Expressions > Functions > Statistical > SKEW
float skew(float data [, ...])
Returns the skewness of the distribution of argument values.
All elements in the argument list are converted to floats, with exclusion if conversion fails. The list may contain array arguments, in which case each array element is treated as a separate list element.
Skewness measures the asymmetry of a dsitribution around its mean. Positive skewness indicates that the distribution is skewed toward (overweight in) positive values, negative skewness that the distribution is skewed toward negative values.
Given N data points, their skewness is
| N | |||||||
| skewness = | N | å | æ | datak - average(data) | ö | 2 | |
| ¾¾¾¾¾¾ | ç | ¾¾¾¾¾¾¾¾¾¾ | ÷ | ||||
| (N - 1)(N - 2) | è | stdev(data) | ø | ||||
| k = 1 |
Example
The expression
=skew(1, 7, 2, 5, 0, 3, 6, 6, 8, 3)
returns -0.0895114944229048.