How to use the CONFIDENCE.NORM function in Excel office 365?
Tags: tousetheconfidenceno, excel, excelfunctions
Published: 2021-08-23 11:52:31

---
title: How to use the CONFIDENCE.NORM function in Excel office 365?
published: true
date: 2021-08-17 18:08:47 UTC
tags: ToUseTheCONFIDENCENO,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-confidence-norm-function-in-excel-office-365/
---

 **CONFIDENCE.NORM** takes the **3 numerical argument** values of **alpha, standard deviation, and size of the sample dataset**. The function returns the margin of error for the given alpha value. In this post, we will explain to you how to **use CONFIDENCE.NORM Function In Excel Office 365.** Let’s see them below!! 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)**

## CONFIDENCE.NORM Function syntax

```
=CONFIDENCE.NORM( alpha, standard_dev, size)
```

**Syntax Explanation:**

- **alpha** : value calculated using **confidence level**. 1 – confidence level.
- **standard\_dev** : **standard deviation** for the given dataset.
- **size** : **sample size** for the dataset.

## Example

- Firstly, you need to **create the sample data** with **mean, standard deviation and size of the dataset.**

![](https://geekexcel.com/wp-content/uploads/2021/08/sample-data-4.png)<figcaption>Sample data</figcaption>

- You have to calculate the margin of error for the **confidence level 90%.**
- Here, **Alpha** would be calculated using the **formula (1-confidence level)** and use this **alpha argument** in the formula.

**The formula for 90% confidence level:**

```
=CONFIDENCE.NORM ( E2, B2, B3)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/confidence-level-90-1024x166.png)<figcaption>confidence level 90%</figcaption>

- Now, the function returns the **value 0.6579** which will be the **margin of error for the 90% confidence level**.
- You need to calculate the margin of error for the **confidence level 95%.**

**The formula for 95% confidence level:**

```
=CONFIDENCE.NORM ( E3, B2, B3)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/confidence-level-95-1024x171.png)<figcaption>Confidence level 95%</figcaption>

- The function returns the **value 0.7839** which will be the **margin of error for the 95% confidence level**.
- Now, you need to calculate the margin of error for the **confidence level 99%.**

**The formula for 99% confidence level:**

```
=CONFIDENCE.NORM ( E4, B2, B3)
```

![](https://geekexcel.com/wp-content/uploads/2021/08/confidence-level-for-99-1024x192.png)<figcaption>The confidence level for 99%</figcaption>

- Then, you can see the **increasing the confidence level** value, and **alpha value gets decreases** but the **margin of error increases**.
- Now, you need to calculate the confidence **interval around the mean for the dataset**.

**The formula for the lower limit of interval:**

```
= 36 - H2
```

![](https://geekexcel.com/wp-content/uploads/2021/08/lowr-limit-1024x257.png)<figcaption>Lower limit value</figcaption>

**The formula for the upper limit of interval:**

```
= 36 + H2
```

![](https://geekexcel.com/wp-content/uploads/2021/08/upper-limit-1024x259.png)<figcaption>Upper limit value</figcaption>

- At last, you have to calculate the confidence interval around the mean of the dataset for both confidence level 95% and 99%.

![](https://geekexcel.com/wp-content/uploads/2021/08/for-all-confidence-level-1024x283.png)<figcaption>For all confidence level</figcaption>

**NOTE:**

- The CONFIDENCE.NORM Function only works with **numbers**.
- If any **argument** other than **cumulative is non-numeric** , the function **returns #VALUE! error**.
- The **function returns #NUM! Error**.
  - If alpha < 0
  - and If alpha > 1
- The **value in decimal** and **value in percentage** is the same value in Excel and **convert the value to percentage** , if required.
- Finally, you can **feed the arguments** to the **function** directly or using the **cell reference,** as explained in the example.

## Wrap-Up

Hope you understood how to **use CONFIDENCE.NORM Function In Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[Excel Formulas to Limit a Percentage Between 0 and 100!!](https://geekexcel.com/excel-formulas-to-limit-a-percentage-between-0-and-100/)**
- **[How to Select Interval Rows or Columns in Excel Office 365?](https://geekexcel.com/how-to-select-interval-rows-or-columns-in-excel-office-365/)**
- **[Excel Formulas to Get the Profit Margin Percentage ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-the-profit-margin-percentage/)**
- **[How to Create Multiple Levels Drop-down list in Excel 365?](https://geekexcel.com/how-to-create-multiple-levels-drop-down-list-in-excel-365/)**