# STDEVP

The **STDEVP** function returns the population standard deviation of a dataset. It measures how widely values are dispersed from the mean, assuming the data represents the entire population. The calculation uses *(n)* in the denominator.

### Syntax

```javascript
STDEVP(number1, [number2], ...)
```

### Arguments

The **STDEVP** function syntax has the following arguments:

* number1, number2, ... - The numeric values for which you want to calculate the population standard deviation. Required.

### Example

<pre class="language-javascript"><code class="lang-javascript"><strong>STDEVP(10, 20, 30, 40, 50)
</strong>// Returns 14.14
</code></pre>

You can use the **STDEVP** function to analyze how widely values are spread from the mean by calculating the population standard deviation for metrics such as sales, revenue, or performance scores.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F6CSpQ22GMFy1I71ZFoWI%2F2026-02-16_17h25_21.png?alt=media&#x26;token=e1c7a7e7-32cc-4e44-9af9-15a674895ef2" alt=""><figcaption><p>STDEVP function</p></figcaption></figure>

{% hint style="info" %}
We used the [**SELECT**](https://docs.inforiver.com/formula-syntax/measure-column-selection-functions/select) function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue)
{% endhint %}

### Excel Equivalent

[STDEVP](https://support.microsoft.com/en-us/office/stdevp-function-1f7c1c88-1bec-4422-8242-e9f7dc8bb195)

{% hint style="info" %}
[**STDEVS**](https://docs.inforiver.com/formula-syntax/statistical-functions/stdevs) calculates the sample standard deviation using *(n − 1)* in the denominator and should be used when working with a sample dataset, whereas **STDEVP** calculates the population standard deviation using *(n)* in the denominator and should be used when working with the entire population.
{% endhint %}

### FAQs

**Q1. How is STDEVP calculated?**

STDEVP (Population Standard Deviation) is calculated by taking the square root of the sum of squared deviations from the mean, divided by *(n)*.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FRUgoziuxGH3cbkb5q3QF%2F2026-02-16_17h29_21.png?alt=media&#x26;token=8bd20746-5c05-424b-aa67-c5d9208c4eac" alt="" width="257"><figcaption></figcaption></figure>

Where:

* x = each value in the dataset
* <img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fslitpr0n5IIdqR8vSl7J%2Fimage.png?alt=media&#x26;token=4d5395e4-8978-4933-b791-684a3e9cd48a" alt="" data-size="line"> = mean of the values
* n = number of values

It measures how widely the values are spread from the mean by calculating the population standard deviation, which is the square root of the [population variance](https://docs.inforiver.com/formula-syntax/statistical-functions/varp).