How to Use Excel STDEV.S Function in Office 365? – [with Examples]
Tags: excelfunctions, excelstdevsfunctioni
Published: 2020-09-17 04:15:29

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

## STDEV.S Function:

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

In this post, you will understand how to use the **Excel STDEV.S 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)

## **STDEV.S Function – Explanation:**

- This function **returns the standard deviation of data based on the given sample**.
- STDEV.S function is similar to the [**STDEV**  **function**](https://geekexcel.com/how-to-use-excel-stdev-function-in-office-365-with-examples/).
- 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:

**=STDEV.S(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 symbols**.
- 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:

Here, we come up with examples to make you understand this function easily.

### Example 1:

- In the below example image, you can see the input numbers are listed in **Column C** , and its standard deviation is printed in the **Cell E3**.

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

### Example 2:

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

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

From the above examples, you can understand how the STDEV.S function works in Excel.

## Bottom-Line:

In this post, you can learn the usage of **Excel STDEV.S Function**  **in Office 365** with its syntax, explanation, and examples. Give your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use Excel RANK Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-rank-function-in-office-365-with-examples/)
- [How to Use Excel MINIFS Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/)