Skip to content

var_s

Sample variance (Excel-compatible).

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

Returns the sample variance — uses N-1 denominator. Equivalent to Excel’s VAR.S and stdev_s(...)^2.

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