VAR_POP with Other Functions
VAR_POP can be combined with ordered analytical functions in a SELECT list, QUALIFY clause, or ORDER BY clause.
VAR_POP cannot be combined with aggregate functions within the same SELECT list, QUALIFY clause, or ORDER BY clause.
GROUP BY Affects VAR_POP Report Breaks
The GROUP BY clause affects the VAR_POP operation.
GROUP BY Clause | Result |
---|---|
Specified | VAR_POP is reported for each individual group. |
Omitted | VAR_POP is reported for all the rows in the sample. |
Measuring Standard Deviation of Population with VAR_POP
If your data represents the only a sample of the entire population for the variable, then use the VAR_SAMP function. See VAR_SAMP.
As the sample size increases, the values for VAR_SAMP and VAR_POP approach the same number, but use the more conservative STDDEV_SAMP calculation unless you are sure your data constitutes the entire population for the variable.