Skip to content

stdev_s

Sample standard deviation (Excel-compatible).

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

Returns the sample standard deviation — uses N-1 denominator. Equivalent to Excel’s STDEV.S. For population standard deviation see stdev_p.

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