STDEV.S

Formulas / STDEV.S
Calculate 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?
The STDEV.S Function is a statistical tool used to calculate the standard deviation of a sample. The standard deviation is a measure of how widely values are dispersed from the average value.
How is the Standard Deviation Calculated?
The standard deviation is calculated using the "n-1" method.
What types of arguments does the STDEV.S Function accept?
The STDEV.S Function accepts numerical, name, array, and reference arguments.
Does the STDEV.S Function ignore values or text in the sample?
Yes, the STDEV.S Function ignores values and text in the sample.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.