You need to enable JavaScript to run this app.
ByteHouse Enterprise Edition

ByteHouse Enterprise Edition

Copy page
Download PDF
Aggregate function
varsamp
Copy page
Download PDF
varsamp

Calculate Σ((x - x̅)^2) / (n - 1), here n is the sample size, is the average value of x.
It represents the unbiased estimate of the variance of a random variable if the values passed form its sample.
Back Float64. When n <= 1, back +∞.

warning

This function uses a numerically unstable algorithm. If you need numerical value stability in Calculating, use the varSampStable function. It works slower, but provides lower calculation errors.

Last updated: 2026.03.31 11:49:59