STDEV.S
Formulas / STDEV.SCalculate the standard deviation for a data set.
STDEV.S(number1,[number2],...)
- number1 - required argument that is the first number argument
- number2, ... - [OPTIONAL] additional number arguments
Examples
=STDEV.S(A2:A11)The STDEV.S function calculates the standard deviation of a sample set of values in Sourcetable. To use this function, simply type the above formula in the cell. This will return the standard deviation of the breaking strength of the data in A2:A11.
=STDEV.S(A2:A11)When trying to determine the standard deviation of a sample set of data in Sourcetable, the STDEV.S is the appropriate function to use. For example, if you have a list of numbers in cells A2 to A11, you can use the formula to calculate the standard deviation of the data.
=STDEV.S(A2:A11)The STDEV.S function is useful for finding the standard deviation of a sample set of data. For example, if you have a list of numbers in cells A2 to A11, you can use it to calculate the standard deviation of the breaking strength of the data in A2:A11 by using the formula above.
=STDEV.S(A2:A11)The STDEV.S function can be used in Sourcetable to calculate the standard deviation of a sample set of values. To use this function, simply type the function above in the cell. This will return the standard deviation of the breaking strength of the data in A2:A11.
Summary
The STDEV.S function is useful for financial analysis, as it calculates the standard deviation of an entire population. For a data set, use the STDEV.P function.
- The STDEV.S function estimates standard deviation in a sample and does not ignore empty cells, logical values, or text in supplied references.
- Use the STDEV.P function for standard deviation in a population.
Frequently Asked Questions
What is the STDEV.S Function?
How is the Standard Deviation Calculated?
What types of arguments does the STDEV.S Function accept?
Does the STDEV.S Function ignore values or text in the sample?
