writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 23:
Line 23: + + + + + + + + + + + + + + + + +
→Description
1. Any one of the argument is non-numeric.
1. Any one of the argument is non-numeric.
2. The arguments containing the error values or text that cannot be translated in to numbers
2. The arguments containing the error values or text that cannot be translated in to numbers
==Examples==
#STDEVIF([19,17,23,10,12,15,22],">10") = 4.1952353926806065
#STDEVIF([22,24,27,32,10,18,45,43,55,14],"<15") = 2.8284271247461903
#STDEVIF([22,24,27,32,10,18,45,43,55,14],">15") = 13.046619704516788
==See Also==
*[[Manuals/calci/STDEV | STDEV]]
*[[Manuals/calci/STDEVP | STDEVP ]]
*[[Manuals/calci/STDEVA | STDEVA]]
==References==
*[http://en.wikipedia.org/wiki/Standard_deviation Standard Deviation]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]