STDEV

Formulas / STDEV
Calculate the standard deviation for a sample.
STDEV(number1,[number2],...)
  • number1 - required, a number or an array or a reference containing numbers
  • number2 - [OPTIONAL] a number

Examples

  • =STDEV(C5:C11)

    The STDEV function in Sourcetable is used to calculate the standard deviation of a set of data. For example, this will return the standard deviation for the data in the range C5:C11.

  • =STDEV(C:C)

    The STDEV function can also be used to calculate the standard deviation of an entire column of data. For example, this will return the standard deviation for all of the data in column C.

  • =STDEV(C5:C11, D5:D11)

    The STDEV function can also be used with multiple arguments. For example, this will return the standard deviation of the two data sets together.

  • =STDEV({1,2,3,4,5})

    The STDEV function can also be used with an array argument. For example, this will return the standard deviation for the array of numbers.

Summary

The STDEV function is a statistical function used to calculate the standard deviation of a sample or population. It requires two or more numerical values and can take up to 255 arguments. The STDEVP or STDEV.P function should be used for population standard deviation.

  • The STDEV function estimates the standard deviation of a sample data set. The standard deviation measures the variability of a data set by calculating the average of all the numbers in the data set.
  • The STDEVP or STDEV.P functions can be used to estimate the standard deviation of an entire population.


Frequently Asked Questions

What is the STDEV Function?
The STDEV function is a statistical function that calculates the standard deviation of a set of data. The standard deviation is a measure of how widely values are dispersed from the average value.
What method is used to calculate the standard deviation?
The "n-1" method is used to calculate the standard deviation.
Does the STDEV function take into account numbers and text representations of numbers?
No, the STDEV function does not take into account numbers and text representations of numbers in its calculation.
What is the difference between the STDEV and STDEVP functions?
The main difference between the STDEV and STDEVP functions is that the STDEVP function includes numbers and text representations of numbers in its calculation. The STDEV function does not take this into account.
Does the STDEV function assume that its arguments are a sample of the population?
Yes, the STDEV function assumes that its arguments are a sample of the population.

Related Functions

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.