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

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

## STDEVPA Function:

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

In this article, we are going to see how to use the **Excel STDEVPA Function in Office 365** with its syntax, explanation, and examples. 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)

## **STDEVPA Function – Explanation:**

- This function **returns the standard deviation of data based on the entire population given as arguments**.
- STDEVPA function evaluates the text value as zero.
- 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:

**=STDEVPA(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.

### Note:

- This function ignores the  **Logical**  **values** , **Empty**  **cells** , and **Error-values**.
- 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:

Refer to the below examples to understand **STDEVPA** Function.

### Example 1:

- In this image, you can see the input values listed in **Column B** , and its output standard deviation value is displayed in the **cell D3**.

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

### Example 2:

- This function ignores the  **Logical**  **values** , **Empty**  **cells** , and **Error-values**.
- STDEVPA function evaluates the text value as zero.

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

From the above examples, you can clearly understand the STDEVPA Function.

## Summary:

In this article, you can learn the usage of **Excel STDEVPA Function in Office 365** with its syntax, explanation, and examples. Leave your **feedback** in the below 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 PERMUT Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-permut-function-in-office-365-with-examples/)