How to Use Excel STDEV.P Function in Office 365? – (with Examples)
Tags: excelfunctions, excelstdevpfunctioni
Published: 2020-09-17 04:15:07

---
title: How to Use Excel STDEV.P Function in Office 365? – (with Examples)
published: true
date: 2020-09-15 11:50:43 UTC
tags: ExcelFunctions,ExcelSTDEVPFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/
---

## Excel STDEV.P Function:

[![STDEV.P Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/STDEV.P-Function.png)](https://geekexcel.com/?attachment_id=13935#main)<figcaption id="caption-attachment-13935">STDEV.P Function</figcaption>

In this article, we are going to explore how to use the **Excel STDEV.P**  **Function in Office 365** with its syntax, explanation, and examples. This function is an advanced edition of the **STDEVP** Function. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **STDEV.P**  **Function – Description:**

- This function **returns the standard deviation based on the entire population given as arguments**.
- You can calculate the **standard deviation** using the below mathematical formula.

![Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-50.png)<figcaption id="caption-attachment-13931">Formula</figcaption>

- To know more about calculating standard deviation mathematically, then visit the following reference tutorial website [https://www.mathsisfun.com/data/standard-deviation-calculator.html](https://www.mathsisfun.com/data/standard-deviation-calculator.html).

## Syntax:

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

### Arguments Explanation:

**Number1 – ** It is the first input number or cell reference.

**Number2 –** It is an optional one. It is the second input number or cell reference.

- This function ignores the **Text** , **Logical**  **values** , **Empty**  **cells** , **Error-values** , and  **Special characters**.
- The standard deviation is calculated using the “ **n** ” method.
- The arguments can be **Numbers** , **Array** , or **References** that contain numbers.

The following table shows the **standard deviation function** provided by Excel.

| Function Name | Data Set | Text and logical Value |
| --- | --- | --- |
| [STDEV](https://geekexcel.com/how-to-use-excel-stdev-function-in-office-365-with-examples/) | Sample | It will be **Ignored** |
| [STDEVP](https://geekexcel.com/how-to-use-excel-stdevp-function-in-office-365-with-examples/) | Population | It will be **Ignored** |
| [STDEV.S](https://geekexcel.com/how-to-use-excel-stdev-s-function-in-office-365-with-examples/) | Sample | It will be **Ignored** |
| [STDEV.P](https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/) | Population | It will be **Ignored** |
| [STDEVA](https://geekexcel.com/how-to-use-excel-stdeva-function-in-office-365-with-examples/) | Sample | It will **Evaluate** |
| [STDEVPA](https://geekexcel.com/how-to-use-excel-stdevpa-function-in-office-365-with-examples/) | Population | It will **Evaluate** |

## Examples:

Let’s see some examples to understand how this function works.

### Example 1:

- In the below screenshot, you can see the input numbers are given in **Column C** , and its **standard deviation** value is printed in the **cell E3**.

[![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-45.png)](https://geekexcel.com/?attachment_id=13933#main)<figcaption id="caption-attachment-13933">Example 1</figcaption>

### Example 2:

- This function ignores the **Text** , **Logical**  **values** , **Empty**  **cells** , **Error-values** , and  **Special characters**.

[![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-15.png)](https://geekexcel.com/?attachment_id=13934#main)<figcaption id="caption-attachment-13934">Example 2</figcaption>

From the above examples, you can clearly understand how to find standard deviation for the given population with the help of the **STDEV.P** function.

## Closure:

In the above article, you can understand the usage of **Excel STDEV.P**  **Function in Office 365** with its syntax, explanation, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel MODE.SNGL Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-mode-sngl-function-in-office-365-with-examples/)
- [How to Use Excel MIN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)