Parameter | Type | Description |
---|---|---|
value | decimal, double | The values from which to take the variance. |
Returns: decimal
Example
query:
SELECT VAR_POP(sales_pipeline.close_value)
FROM sales_pipeline
WHERE deal_stage = "Won"
result:
var_pop |
---|
6,472,873.47 |
Population Variance.
Parameter | Type | Description |
---|---|---|
value | decimal, double | The values from which to take the variance. |
query:
SELECT VAR_POP(sales_pipeline.close_value)
FROM sales_pipeline
WHERE deal_stage = "Won"
result:
var_pop |
---|
6,472,873.47 |
CORRELATION
, COVAR_POP
, COVAR_SAMP
, STD_POP
, STD_SAMP
, STDEV
, VAR_SAMP
, VARIANCE
, SKEWNESS
, KURTOSIS