Syntax
=STDEV(number1, [number2], ...)Arguments
| Argument | Required | Description |
|---|---|---|
number1 | Required | A number, cell or range |
number2 | Optional | More numbers or ranges |
How to use STDEV
STDEV is kept so older workbooks keep working. It calculates the same way as STDEV.S, which is the name to use in new formulas.
STDEV takes 1 required argument and 1 optional argument, and accepts more values in the same pattern. Type =STDEV( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=STDEV(2, 4, 4, 4, 5, 5, 7, 9)Result Related compatibility functions
- PERCENTRANKReturns the percentage rank of a value in a data set (older name of PERCENTRANK.INC).
- POISSONReturns the Poisson distribution (older name of POISSON.DIST).
- QUARTILEReturns a quartile of the values (older name of QUARTILE.INC).
- RANKReturns the rank of a number in a list (older name of RANK.EQ).
- STDEVPReturns the population standard deviation (older name of STDEV.P).
- TDISTReturns the one or two tailed Student's t distribution (older form of T.DIST.RT and T.DIST.2T).
- TINVReturns the two tailed inverse of the Student's t distribution (older name of T.INV.2T).
- TTESTReturns the probability of a Student's t test (older name of T.TEST).
- VAREstimates the variance from a sample (older name of VAR.S).