SKEW function
SKEW measures how lopsided a set of data is, using the sample formula. Positive means a long tail to the right, negative a long tail to the left, which helps when checking data like incomes.
Example
Read it as a sentence: measure how lopsided the values in A1:A8 are, treating them as a sample, which gives 0.818487553.
Excel shows 0.818487553
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
Syntax
SKEW(number1, [number2], ...)
Arguments in [square brackets] are optional.
-
number1(required) - First number or range.
-
number2(optional) - More numbers or ranges.
Returns: The sample skewness of the data.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=SKEW({2,4,4,4,5,5,7,9}) | 0.818487553 | Array constant |
=SKEW(10,"20",TRUE) | 0.157627767 | Direct args: number, text-number, TRUE |
=SKEW(Data!A1:A8) | 0.818487553 | Range of numbers |
=SKEW(Data!B1:B8) | -0.93521953 | Mixed range: num, text-number, TRUE, blank, text, FALSE |
=SKEW(Data!A1:A4,Data!F1:F5) | -0.519943676 | Two ranges |
=SKEW(10,"abc") | #VALUE! | Direct arg: non-numeric text |
=SKEW(5) | #DIV/0! | Single number |
=SKEW({1,"2",TRUE,3}) | #DIV/0! | Array with text and boolean |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
B
F
1
2
10
1
2
4
20
2
3
4
TRUE
3
4
4
4
5
5
abc
5
6
5
30
7
7
FALSE
8
9
40
Data
Watch out for
- Needs at least three data points.
- Uses the sample formula; use SKEW.P for a full population.
Where it works
- Excel
- SKEW is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .