How to Use Excel STDEV Function in Office 365? – [with Examples]
Tags: excelfunctions, excelstdevfunctionin
Published: 2020-09-15 08:22:58

---
title: How to Use Excel STDEV Function in Office 365? – [with Examples]
published: true
date: 2020-09-15 06:53:36 UTC
tags: ExcelFunctions,ExcelSTDEVFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-stdev-function-in-office-365-with-examples/
---

## Excel STDEV Function:

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

In this tutorial, we will guide you to learn the usage of **Excel STDEV**  **Function in Office 365** with its syntax, explanation, 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)

## **STDEV**  **Function – Explanation:**

- This function **returns the standard deviation of data based on the given sample**.
- 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>

## **Syntax:**

**=STDEV(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** , 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 | Sample | It will be Ignored |
| STDEVP | Population | It will be Ignored |
| STDEV.S | Sample | It will be Ignored |
| STDEV.P | Population | It will be Ignored |
| STDEVA | Sample | It will Evaluate |
| STDEVPA | Population | It will Evaluate |

## **Examples:**

Here, we come up the examples to clearly understand **STDEV** Function.

### Example 1:

- In the below screenshot, you can see the input values in **Column C** , and its standard deviation is displayed in the **cell E3**.

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

### Example 2:

- This function ignores the **Text** , **Logical**  **values** , **Empty**  **cells** , and **Error-values, special symbols**.

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

From the above image, you can see that the STDEV function always ignores the inputs which contain text, logical values, non-numerical characters, and error values and calculate the standard deviation of numbers and it will be printed in the desired cell.

## **Verdict:**

In this tutorial, we guided you to learn the usage of **Excel STDEV**  **Function in Office 365** with its syntax, explanation, and examples. Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Ahead:

- [How to Use Excel COUNTBLANK Function in Office 365?](https://geekexcel.com/how-to-use-excel-countblank-function-in-office-365/)
- [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/)