How to Use Excel STDEVA Function in Office 365? – [with Examples]
Tags: excelfunctions, excelstdevafunctioni
Published: 2020-09-17 04:15:56

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

## STDEVA Function:

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

This article describes the usage of **Excel STDEVA Function in Office 365** with its syntax, definition, and examples. Let’s get 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)

## **STDEVA Function – Definition:**

- This function **returns the standard deviation of data based on the given sample**.
- STDEVA function evaluates the text values as zero.
- The logical values **TRUE** & **FALSE** is evaluated as **1** & **0**.
- You can calculate the **standard deviation** using the below mathematical formula.

![Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/mspaint_BEXhHFvRpm.png)<figcaption id="caption-attachment-13919">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:

**=STDEVA(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  **Empty**  **cells**  and **Error-values**.
- The standard deviation is calculated using the “ **n-1** ” 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:

We come up with examples to show you clearly how **STDEVA** Function will work.

### Example 1:

- In the below screenshot, you can see the input numbers 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-52.png)<figcaption id="caption-attachment-13954">Example 1</figcaption>

### Example 2:

- This function ignores the  **Empty**  **cells**  and **Error-values**.
- STDEVA function evaluates the text values as zero.
- The logical values **TRUE** & **FALSE** is evaluated as **1** & **0**.

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

From the above examples, you can understand the **STDEVA** Function clearly.

## End of the Article:

In this article, you can learn the usage of **Excel STDEVA Function in Office 365** with its syntax, definition, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!