In this article, we will learn to calculate **population standard deviation** in Excel. We can do it very quickly by following the methods discussed in this tutorial. Here, we will demonstrate the steps with **screenshots** so that you can understand them easily. Let’s see the methods below.

**Table of Contents**Expand

## Introduction to Standard Deviation

Standard deviation calculates the variance of a list of numbers from their **mean**. It can be classified into **two** categories, **sample** and **population** standard deviations. There is a slight difference between these two types of standard deviations.

**Sample Standard Deviation: **It does not include all the numbers in the list. The basic formula for determining sample standard deviation is:

`S = √Σ (x – ⲙ)`

^{2 }`/ (n - 1)`

Here,

**x** denotes any number or value in the list.

**ⲙ** is the mean or average of the numbers.

**n** denotes the total number of values in the list.

**Population Standard Deviation:** It includes all the numbers in the calculation. For example, a teacher always uses **population** standard deviation to summarize the marks of the students. The following formula is used to calculate the population standard deviation:

`S = √Σ (x – ⲙ)`

^{2 }`/ n`

Here,

**x** indicates any number or value in the list.

**ⲙ** denotes the mean or average of the numbers.

**n** is the total number of values in the list.

## Built-In Excel Functions for Population Standard Deviation

There are **3 built-in** functions in Excel that calculate the **population standard deviation** at once. These functions also use the **basic formula** for determining the standard deviation. But here the basic formula is **built** into these functions. So, we do not need to insert the long formula if we use the **built-in** functions. The functions are below.

**STDEVP Function: **This is the **oldest** function for calculating population standard deviation. Though it is now replaced with some new functions, it is available in the modern versions of Microsoft Excel. The syntax of this function is:

`=STDEVP (number1, [number2],…)`

**STDEV.P Function: **It is the new version of the **STDEVP function** that provides higher precision. We can use this formula in the modern version of Microsoft Excel (2010 and later versions). The syntax is below:

`=STDEV.P (number1, [number2],…)`

The **STDEVP** and **STDEV.P** functions do not evaluate the **text** and **logical** values in references. But, these functions evaluate the **text** or **logical** values if they are in the **argument** list.

**STDEVPA Function:** This function computes the population standard deviation considering **text** and **logical** values. The syntax of this function is:

`=STDEVPA (value1, [value2], …)`

## 2 Easy Ways to Calculate Population Standard Deviation in Excel

Suppose, we have a dataset (**B4:D9**) in Excel that contains the **Name** of some **Students**, their student **IDs**, and their **Marks** in the Exam. Let’s say, we need to calculate the **population standard deviation** of the **Marks **(**D5:D9**). Here, we will discuss **2** easy ways to do so. So, without further delay, let’s begin.

### 1. Calculate Population Standard Deviation Manually in Excel

In this method, we will calculate the **population standard deviation** of the **Marks** (**D5:D9**) in Excel using the **basic formula**. We have already discussed the basic formula in the **introduction** part. Here, we will use the dataset (**B4:D9**) below where we have denoted the **Mark** column as **x** in the formula. The steps are below.

**Steps:**

- First of all, we need to calculate the
**Average Mark**. - To calculate the
**Average Mark**, insert the following formula in cell**D11**:

`=AVERAGE(D5:D9)`

- After that, press the
**Enter**key. - Therefore, we will find the
**Average Mark**in cell**D11**by using the**AVERAGE function**.

- Afterward, create a column (
**E4:E9**) with**(x –****ⲙ****)**as the column heading.

- At this time, to find the difference between the
**Mark**of the first student (cell**D5**) and the**Average Mark**(cell**D11**), type the following formula in cell**E5**:

`=D5-$D$11`

- Next, hit the
**Enter**key. - Consequently, you will find the difference in cell
**E5**(see the screenshot below).

- In order to
**autofill**the rest of the cells (**E6:E9**), move your**cursor**to the**bottom-right**corner of cell**E5**. - Momentarily, you will see a
**plus**sign (**+**) that is called the**fill handle**.

- Thereupon,
**double-click**on the**fill handle**. - Hence, you will get all the values of
**(x –****ⲙ****)**. - See the picture below.

- Later, add another column (
**F4:F9**) for determining**(x –****ⲙ****)**.^{2}

- Calculate
**(x –****ⲙ****)**for the first student by entering the formula below in cell^{2}**F5**:

`=E5^2`

- Hit
**Enter**to get the output.

- Eventually,
**double-click**on the**plus**sign to**autofill**the rest of the cells (**F6:F9**).

- Accordingly, use the
**SUM function**to get the summation of the range**F5:F9**, in cell**D12**. - See the formula below.

`=SUM(F5:F9)`

- After pressing the
**Enter**button, you will find the output.

- Finally, find the
**Population Std. Deviation**by applying the formula with the**SQRT function**and the**COUNT function**. - We used the following formula in cell
**D13**:

`=SQRT(D12/COUNT(D5:D9))`

- Lastly, hit the
**Enter**button to get the final output. - See the final result in cell
**D13**of the figure below.

🔎 **How Does the Formula Work?**

**COUNT(D5:D9):**It returns the total number of values in the**D5:D9**range.**SQRT(D12/COUNT(D5:D9)):**Provides the square root of the value obtained from**D12/COUNT(D5:D9)**.

**Read More: **How to Calculate Standard Deviation of y Intercept in Excel

### 2. Use Built-In Excel Functions to Determine Population Standard Deviation

In this approach, we will show you the use of three **built-in** Excel functions for determining **population standard deviation**. We already discussed these functions at the beginning of this tutorial. So, let’s see the process below to apply the functions.

#### 2.1 Insert STDEVP Function

Here, we will use the** STDEVP function** in Excel to find the **population standard deviation**. For this, we will use the same dataset (**B4:D9**) that we used in the previous method. Here, we want to keep the result in cell **D11**. See the following steps.

**Steps:**

- Firstly, go to cell
**D11**. - Then, determine the
**population standard deviation**of the**Marks**by entering the formula below in cell**D11**:

`=STDEVP(D5:D9)`

- After that, hit the
**Enter**button. - In this way, you will get the desired result in cell
**D11**(see screenshot).

#### 2.2 Assign STDEV.P Function

Now, we will apply the** STDEV.P function** in Excel to calculate the **population standard deviation** of the **Marks** in cell **D11**. Here, you will use the same dataset as the previous methods. The steps are below.

**Steps:**

- First, activate cell
**D11**by clicking on it.

- Secondly, type the following formula in the cell to determine the
**population standard deviation**:

`=STDEV.P(D5:D9)`

- Thirdly, press
**Enter**. - Thus, you will find the result in cell
**D11**. - See the following figure.

#### 2.3 Enter STDEVPA Function

This approach will guide you to use the** STDEVPA function** for calculating the **population standard deviation**. For this, we will use the same dataset as the previous methods. See the following steps:

**Steps:**

- To begin, select cell
**D11**.

- Next, find the
**population standard deviation**of the**Marks**by using the formula below in cell**D11**:

`=STDEVPA(D5:D9)`

- In the end, press the
**Enter**button on the keyboard. - Consequently, you will find the desired output in cell
**D11**(see screenshot).

**Read More: **How to Calculate Standard Deviation with IF Conditions in Excel

**Download Practice Workbook**

Download the practice workbook from here.

## Conclusion

I hope the above tutorial will be helpful for you to calculate the population standard deviation in Excel. Download the practice workbook and give it a try. Let us know your feedback in the comment section.

## Related Articles

- How to Calculate Standard Deviation of a Frequency Distribution in Excel
- Calculate Percentile from Mean and Standard Deviation in Excel
- How to Calculate Uncertainty in Excel

**<< Go Back to Standard Deviation Formula in Excel | Excel for Statistics**** | Learn Excel**