writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 75:
Line 75: − + − + −
no edit summary
|}
|}
=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column in the range A4 to C10, for the cells with 40>Age>32. <br /> ''Returns 5.214829282387338'' as a result.
=DSTDEV(A4:C10,"Age",B1:B3) : Calculates the standard deviation for 'Age' column in the range A4 to C10, for the cells with 40>Age>30. <br /> ''Returns 5.214829282387338'' as a result.
=DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary' in the range A4 to C10, for the cells with Age>30. <br />''Returns 1981.161275615895'' as a result.
=DSTDEV(A4:C10,3,D1:D2) : Calculates the standard deviation for 'salary' in the range A4 to C10, for the cells with Age>32. <br />''Returns 1981.161275615895'' as a result.
== See Also ==
== See Also ==
*[[Manuals/calci/DSTDEVP| DSTDEVP]]
*[[Manuals/calci/DSTDEVP| DSTDEVP]]