Skip to content

stdev_p

Population standard deviation (Excel-compatible).

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

Returns the population standard deviation — uses N denominator. Equivalent to Excel’s STDEV.P. Use when the data is the entire population.

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