The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, ...

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.