Calculates standard deviation based on the entire population given as arguments.
Syntax Copy Code |
---|
STDEVP( Number n1, [Number n2], ... ) → Number |
The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. If the specified arguments do not contain at least one number, the function returns #N/A.
Formula Copy Code |
---|
=STDEVP({1245;1201;1268;1222;1211}) |
Function Reference
STDEV Function
AVERAGE Function