SKEWNESS_SAMP

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the sample skewness of input values, with a bias correction for finite samples. 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_SAMP when the data is a sample drawn from a larger population, the typical analytics case. Use SKEWNESS_POP when the data is the complete population of interest.
  • Uses the adjusted Fisher–Pearson coefficient of skewness, with finite-sample bias correction.
  • Converges with SKEWNESS_POP for large row counts.
  • Ignores NULL inputs. Any NaN or infinite input propagates to a NaN result.

Estimate the skewness of service latency from a sampled slice of requests.

Compare the asymmetry of claim amounts across policy lines.