Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SKEW
SKEW measures the degree and direction of asymmetry in a dataset: positive skew means a longer right tail, negative skew means a longer left tail, and zero indicates a symmetric distribution. Use it in quality control, risk analysis, or any situation where you need to understand whether extreme high or low values dominate.
Excel
=SKEW(A2:A5)Google Sheets
=SKEW(A2:A5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Amount |
| 20 |
| 35 |
| 40 |
| 200 |
=SKEW(A2:A5)→1.9386059081
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Collect at least three numeric data points in a range.
- 2Enter =SKEW(range) to compute the skewness coefficient.
- 3Interpret: values near 0 are roughly symmetric; positive values indicate a right-skewed distribution; negative values indicate left skew.
Need a version for your data?
Try: “Check whether our customer purchase amounts are skewed toward very large or very small orders”