VAR_POP

1
SELECT
2
  VAR_POP(score) as population_variance,
3
  VAR_SAMP(score) as sample_variance,
4
  VARIANCE(score) as variance_alias,
5
  COUNT(*) as n
6
FROM `project.dataset.all_test_scores`;

1
SELECT
2
  machine_id,
3
  AVG(output_quantity) as avg_output,
4
  VAR_POP(output_quantity) as output_variance,
5
  STDDEV_POP(output_quantity) as output_stddev
6
FROM `project.dataset.production_log`
7
WHERE production_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
8
GROUP BY machine_id
9
ORDER BY output_variance DESC;

1
SELECT
2
  category,
3
  VAR_POP(price) as variance_pop,
4
  STDDEV_POP(price) as stddev_pop,
5
  POWER(STDDEV_POP(price), 2) as stddev_squared,
6
  ABS(VAR_POP(price) - POWER(STDDEV_POP(price), 2)) < 0.0001 as are_equal
7
FROM `project.dataset.products`
8
GROUP BY category;