O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SKEW()

Syntax. SKEW(number1,number2,...)

Definition. This function returns the skewness of a distribution. The skewness characterizes the degree of asymmetry of a distribution around its mean. A positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. This distribution is also called left-skewed distribution. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

Arguments

  • number1 (required) and number2 (optional). At least one and up to 255 arguments (30 in Excel 2003 and earlier versions) for which you want to calculate the skewness. You can also use a single array or a reference to an array instead of arguments separated by commas.

Note

Arguments ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required