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