Skip to content

var_p

Population variance (Excel-compatible).

v = var_p(number1, number2, ...)

Returns the population variance — uses N denominator. Equivalent to Excel’s VAR.P.

var_p(2, 4, 4, 4, 5, 5, 7, 9) % 3.5
  • var_s — Sample variance (Excel-compatible).
  • varpa — Population variance including text and logicals.
  • stdev_p — Population standard deviation (Excel-compatible).