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.

  • <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.

Compare the asymmetry of score distributions across cohorts.