STDEV returns the standard deviation of a set of values
Syntax
- STDEV(Pno%, Ndim%, "ColLab$_1",.., "ColLab$_Ndim%")
- STDEV(0, Npoints%, x_1, y_1, x_2, y_2,...)
- STDEV(@ObjFn(..), Ndim%, @ObjColPar_1,.., @ObjColPar_Ndim%)
- STDEV(Telitab$, Ndim%, "ColLab$_1",.., "ColLab$_Ndim%")
...
- See also Telitab access for a generic description on the use of TeLiTab data
- Similar to other Data analysis functions, the STDEV is a convenient way to evaluate data. Please also look at these functions for syntax examples
- For a multi-dimensional dataset the STDEV will be determined over all columns.
- The standard deviation is calculated using the "nonbiased" or "n-1" method.
- STDEV uses the following formula:
SQRT(n*Sigma_X^2 - (Sigma_X)^2/(n*(n-1)))
...
Suppose 10 engine parts made by the same machine during a production run are collected as a random sample and measured for breaking strength. STDEV estimates the standard deviation of breaking strengths for all the parts. The sample values are provided in the STDEV function as follows:
SET$=
0
1 "Strength"
"1" 1465
"2" 1421
"3" 1457
"4" 1428
"5" 1416
"6" 1477
"7" 1422
"8" 1452
"9" 1412
"10" 1409
STDEV(SET$, 1, "Strength") returns 24.52
...