How to Use Excel STDEVP Function in Office 365? – [with Examples]
Tags: excelfunctions, excelstdevpfunctioni
Published: 2020-09-17 04:16:21

---
title: How to Use Excel STDEVP Function in Office 365? – [with Examples]
published: true
date: 2020-09-15 12:04:50 UTC
tags: ExcelFunctions,ExcelSTDEVPFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-stdevp-function-in-office-365-with-examples/
---

## STDEVP Function:

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

In this article, we are going to see the usage of **Excel STDEVP Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! 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)

## **STDEVP Function – Explanation:**

- This function **returns the standard deviation of data based on the entire population given as arguments**.
- The STDEVP Function is similar to **STDEV.P Function in Excel**.
- 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:

**=STDEVP(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 this concept.

### Example 1:

- In the below screenshot, you can see the input numbers given in **Column B** , and its standard deviation value is printed in the **Cell D3**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-53.png)<figcaption id="caption-attachment-13960">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/2-48.png)<figcaption id="caption-attachment-13961">Example 2</figcaption>

From the above example image, you can see that the STDEVP function ignores the logical values, text, empty cells, and special symbols then print the output standard deviation value in the desired cell.

## Sum-Up:

To sum up, I hope this article helped you to learn the usage of **Excel STDEVP Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

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