The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

Variance is a measurement of the spread between numbers in a data set. Investors use the variance equation to evaluate a portfolio’s asset allocation.