How to Use the STDEVP Function in Excel

Below is a detailed guide on how to use the STDEVP function in Microsoft Excel and Google Sheets.

Overview

The STDEVP function calculates the standard deviation of an entire population using the numbers provided as arguments.

Syntax

The syntax for the STDEVP function is identical in both Microsoft Excel and Google Sheets:

=STDEVP(number1, [number2], ...)

Arguments

  • number1 (required): The first numeric argument or range where you want to compute the standard deviation.
  • number2, … (optional): Subsequent numbers or ranges to include in the standard deviation calculation.

Examples

Consider an example using a list of numbers in cells A1 to A5:

Data
10
20
30
40
50

To calculate the standard deviation for the entire population in this scenario, use the formula:

=STDEVP(A1:A5)

Use Case

The STDEVP function is particularly useful when dealing with data representing an entire population rather than just a sample. For example, to find the standard deviation of the heights of all students in a school, STDEVP would be the appropriate function to use, since it encompasses every individual measurement.

This guide should give you a thorough understanding of how to utilize the STDEVP function in Microsoft Excel and Google Sheets for calculating the standard deviation of a dataset.

More information: https://support.microsoft.com/en-us/office/stdevp-function-1f7c1c88-1bec-4422-8242-e9f7dc8bb195

Other functions
Returns the beta cumulative distribution function
Returns the inverse of the cumulative distribution function for a specified beta distribution
Returns the individual term binomial distribution probability
Returns the one-tailed probability of the chi-squared distribution
Returns the inverse of the one-tailed probability of the chi-squared distribution
Returns the test for independence
Returns the confidence interval for a population mean
Returns covariance, the average of the products of paired deviations
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Returns the exponential distribution
Returns the F probability distribution
Rounds a number down, toward zero
Returns the result of an F-test
Returns the gamma distribution
Returns the inverse of the gamma cumulative distribution
Returns the hypergeometric distribution
Returns the inverse of the lognormal cumulative distribution
Returns the cumulative lognormal distribution
Returns the most common value in a data set
Returns the negative binomial distribution
Returns the inverse of the normal cumulative distribution
Returns the normal cumulative distribution
Returns the standard normal cumulative distribution
Returns the inverse of the standard normal cumulative distribution
Returns the k-th percentile of values in a range
Returns the percentage rank of a value in a data set
Returns the Poisson distribution
Returns the quartile of a data set
Returns the rank of a number in a list of numbers
Estimates standard deviation based on a sample
Returns the Student's t-distribution
Returns the inverse of the Student's t-distribution
Returns the probability associated with a Student's t-test
Estimates variance based on a sample
Calculates variance based on the entire population
Calculates variance based on the entire population, including numbers, text, and logical values
Returns the one-tailed probability-value of a z-test