# Excel STDEV.P function

## Summary

The Excel STDEV.P function calculates the standard deviation of a dataset that represents an entire population. Unlike STDEV, which is used for samples, STDEV.P provides a measure of how spread out numbers are from the mean (average) for the whole population. This function is crucial for statistical analysis across various domains, offering insights into the variability or consistency of a complete set of data values.
##### Syntax
```				```
=STDEV.P(number1, [number2], ...)
```
```
• number1: The first number, cell reference, or range in the population.
• number2, …: [Optional] Additional numbers, cell references, or ranges, up to 255.
##### Return value
The standard deviation of the population.

## How to use

Input directly numbers or specify cell references/ranges containing the population data. STDEV.P considers only numeric values, ignoring text, logical values, and empty cells. It’s used when analyzing the variability of data that represents every member of a group or category.

## Examples

##### Simple STDEV.P
Calculating Population Standard Deviation for Company Sales: To evaluate the consistency of sales across all branches of a company.
```				```
=STDEV.P(A1:A50)
```
```
If A1:A50 contains sales figures for every branch, STDEV.P calculates the standard deviation of these sales, indicating how consistently branches are performing in terms of sales volume compared to the average.
##### STDEV.P with Direct Values
Assessing Variability Amongst Defined Values: To determine the spread of specific revenue figures.
```				```
=STDEV.P(10000, 20000, 15000, 25000, 30000)
```
```
This formula calculates the standard deviation of directly specified revenue figures, measuring how much the revenues vary from their average value.
##### STDEV.P Across Multiple Ranges
Understanding Dispersion in Combined Data Sets: To calculate the standard deviation for combined employee performance ratings.
```				```
=STDEV.P(B2:B10, D2:D10)
```
```
Assuming B2:B10 and D2:D10 contain performance ratings from two different departments, STDEV.P evaluates both sets of ratings to compute the standard deviation, offering insights into overall performance variability across departments.