STDEVA

Formulas / STDEVA
Calculate the standard deviation for a sample of data.
=STDEVA(value1, [value2], ...)
  • value1, value2, ... - 1 to 30 values from a sample of a population

Examples

  • =STDEVA(A3:A12)

    If you want to calculate the standard deviation of a set of numbers in column A of your Sourcetable sheet, you can use the STDEVA function. For example, this will calculate the standard deviation of the breaking strength for all the items in column A.

  • =STDEVA(A3:A12)

    The STDEVA function is useful when you want to measure the spread of a set of values in a dataset. For instance, if you have a set of test scores in column A, you could use the STDEVA function to calculate the standard deviation of those scores.

  • =STDEVA(A3,B3,C3)

    The STDEVA function can also be used to calculate the standard deviation of a set of numbers that are not in a single column. For example, if you have a set of numbers in cells A3, B3, and C3, you can use the STDEVA function to calculate the standard deviation of those numbers.

  • =STDEVA(A3:C12)

    You can use the STDEVA function to calculate the standard deviation of a set of numbers that are spread across multiple columns. For example, if you have a set of numbers in columns A, B, and C, you can use the STDEVA function to calculate the standard deviation of those numbers.


Summary

The STDEVA function calculates the standard deviation of a sample population, measuring the spread of values from the average. It assumes that the arguments are from the population.

  • The STDEVA function calculates standard deviation for a sample of data using the "n-1" method, assuming the data is a sample of a population.
  • To calculate standard deviation for an entire population, use the STDEV or STDEV.P functions instead.

Frequently Asked Questions

What is the STDEVA function?
The STDEVA function is a statistical function that calculates the standard deviation of a sample of a population. The standard deviation is a measure of how much the values in the sample differ from the average value.
What is the STDEVA function assuming?
The STDEVA function assumes that its arguments are a sample of the population.
How does the STDEVA function calculate the standard deviation?
The STDEVA function uses the "n-1" method to calculate the standard deviation.
What type of arguments can be used with the STDEVA function?
The STDEVA function can accept arguments that are numbers, names of arrays, or references to contain numbers. Arguments can also be text representations of numbers or real numbers, or logical values such as TRUE and FALSE.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV