STDEVPA

Formulas / STDEVPA
Calculate the standard deviation for a population.
=STDEVPA(value1,value2,value3,...[up to 30 values])
  • number1 - required, first number or reference in the sample
  • number2 - [OPTIONAL], second number or reference in the sample

Examples

  • =STDEVPA(A3:A12)

    The STDEVPA function is used to calculate the standard deviation of a set of data points. For example, if you have a set of breaking strength values in a range of cells from A3 to A12, you can use the function to calculate the standard deviation of those values.

  • =STDEVPA(A3:A12)

    The STDEVPA function can also be used to calculate the standard deviation of data points within a column. For example, if you have a column of breaking strength values in column A starting at row 3, you can use the function to calculate the standard deviation of those values.

  • =STDEVPA(A3:B12)

    The STDEVPA function can also be used to calculate the standard deviation of data points within a range of cells. For example, if you have a range of breaking strength values in cells A3 to B12, you can use the function to calculate the standard deviation of those values.

  • =STDEVPA(A3:A12)

    The STDEVPA function can also be used to calculate the standard deviation of data points within a range of rows. For example, if you have a range of breaking strength values in row 3 to row 12 in column A, you can use the function to calculate the standard deviation of those values.


Summary

The STDEVPA function calculates the population standard deviation for a set of up to 30 values in a Sourcetable worksheet. It ignores blank cells, TRUE, FALSE and text strings, making it suitable for completely numeric data.

  • The STDEVPA function evaluates text and logicals as numbers in the calculation, meaning that it can take into account values that are not numerical, such as TRUE and FALSE.
  • The STDEVPA function is used to estimate the standard deviation of a population of data.

Frequently Asked Questions

What is the STDEVPA function?
The STDEVPA function is a statistical function used to calculate the standard deviation of a population. It takes numerical, text, array, or references to array arguments.
How does the STDEVPA function work?
The STDEVPA function uses the "n" method to calculate the standard deviation. It assumes all arguments are part of the population.
What types of arguments can be used in the STDEVPA function?
  • Numerical
  • Text
  • Array
  • References to arrays

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