SKEWNESS_POP

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the population skewness of input values. Skewness measures the asymmetry of a distribution: positive values indicate a longer right tail, negative values indicate a longer left tail, and zero indicates a symmetric distribution.

1skewness_pop(<expression>)

• <expression>: An expression of any numerical type.

Returns a double precision value.

Returns NULL when fewer than three non-null input values are provided or when all non-null values are identical.

• Use SKEWNESS_POP when the data is the complete population of interest (for example, every order in a closed quarter). Use SKEWNESS_SAMP when the data is a sample drawn from a larger population.
• Computes the Fisher–Pearson population coefficient of skewness, without bias correction.
• For large row counts, SKEWNESS_POP and SKEWNESS_SAMP converge.
• Ignores NULL inputs. Any NaN or infinite input propagates to a NaN result.

Check whether last quarter’s order totals are skewed toward a few large purchases.

1SELECT skewness_pop(order_total) AS order_total_skew
2FROM orders
3WHERE order_quarter = '2026-Q1';

Compare the asymmetry of score distributions across cohorts.

1SELECT cohort, skewness_pop(score) AS score_skew
2FROM exam_results
3GROUP BY cohort;

• SKEWNESS_SAMP
• KURTOSIS
• STDDEV_POP
• Aggregate Functions