Excel is extremely powerful for analyzing data and handling large datasets. Sometimes, statistical calculations are necessary for interpreting a large dataset. Excel is one of the best tools to calculate mean, standard deviation, confidence interval, etc. In this article, I will show you step-by-step guidelines to calculate a **90** percent **confidence interval** in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download our practice workbook from here for free!

## Introduction to Excel CONFIDENCE Function

**CONFIDENCE function** is an Excel function that will help you to find specific data points centering around the mean of a dataset. To use this function, you will need the standard deviation of the dataset, the significance level, and the sample size of your dataset.

**Arguments:**

This function has mainly **3** arguments. Such as:

* alpha:* This is the significance level to which you want to calculate the confidence interval.

* standard_dev: *This is the standard deviation of your dataset.

* size:* This is the sample size of your dataset.

## What Does 90% Confidence Interval Mean?

To put it in one word, a 90 confidence interval will show you the values around 90% center of the mean value of your dataset.

Say, you have a mean value of 60 for your dataset. Now, you calculated the confidence value of your dataset as 5 using the significance level as 0.1 for a 90 percent confidence interval. Then, the confidence interval result at 90 confidence interval for this whole scenario will be 55-65.

## Steps to Calculate 90 Percent Confidence Interval in Excel

Say, you have a dataset containing 10 studentsâ€™ Ids and their respective marks. Now, you want to calculate the 90 percent confidence interval of this dataset. You can follow the step-by-step guidelines easily to accomplish your desired result.

We have used the **Office 365** version of Microsoft Excel here. But, no worries! You can easily apply these steps in any version of Microsoft Excel according to your availability. If you face any problems regarding versions, please feel free to comment below.

### ðŸ“Œ Step 1: Calculate Mean Value

First and foremost, you need to calculate the mean value of your dataset by using the **AVERAGE function.**

- To do this, select the
**F4**cell first. - Now, insert the following formula in the formula bar.

`=AVERAGE(C5:C14)`

- Subsequently, hit the
**Enter**button.

Thus, you will find the mean mark of the studentsâ€™ marks.

**Read More:** **Excel Confidence Interval for Difference in Means (2 Examples)**

### ðŸ“Œ Step 2: Calculate Standard Deviation

Next, you will need to know the standard deviation of the dataset by using the **STDEV.P function.**

- In order to do this, click on the
**F5**cell. - Afterward, insert the following formula and press the
**Enter**button.

`=STDEV.P(C5:C14)`

Consequently, you will get the standard deviation of your dataset.

**Read More:** **How to Find Upper and Lower Limits of Confidence Interval in Excel**

### ðŸ“Œ Step 3: Apply CONFIDENCE Function to Calculate Confidence

At this time, you will need to **calculate the confidence value** of the dataset according to the desired significance level.

- In doing this, at the very beginning, click on the
**F6**cell and put the significance level value. - The significance level is calculated as 1- (% of the confidence level). As you need a 90 percent confidence interval, write
**0.1**in the**F6**cell and press the**Enter**button.

- Now, click on the
**F7**cell and put 10 as the cell value.

- Afterward, click on the
**F8**cell and insert the following formula.

`=CONFIDENCE(F6,F5,F7)`

- Subsequently, hit the
**Enter**button.

Thus, you have found the confidence function value for the 90 percent confidence interval.

**Read More:** **How to Calculate Z-Score with 95 Confidence Interval in Excel**

### ðŸ“Œ Step 4: Find 90 Percent Confidence Interval

Finally, you need to calculate the 90 percent confidence interval by concatenating two cells and using the **TEXT function**.

- To do this, click on the
**F9**cell. - Subsequently, insert the following formula and press the
**Enter**button.

`=F4&" Â± "&TEXT(F8,"##,##.##")`

Thus, the 90 percent confidence interval in Excel is calculated successfully. And, for example, the whole result sheet would look like this now.

**Read More:** **How to Calculate 95 Percent Confidence Interval in Excel (4 Ways)**

## ðŸ’¬ Things to Remember

- When finding the standard deviation, you may encounter two similar functions named
**STDEV.P**and**STDEVPA**.Use the**STDEV.P**function here as it ignores the non-numerical data. - In Excel 2010, you will find the
**CONFIDENCE**function as**CONFIDENCE.NORM**function. - The value of the
**alpha**argument inside the**CONFIDENCE**function can not be less than or equal to 0. Else, it would show**#NUM!**error. - The
**standard_dev**argument has to be greater than zero to avoid the**#NUM!**error. - The
**size**argument must be greater than one to avoid the**#NUM!**error. - If the size argument is not an integer, it would be truncated.
- The
**CONFIDENCE**function will show**#VALUE!**Error, if any argument is non-numeric.

## Conclusion

In a nutshell, in this article, I have shown you step-by-step guidelines to calculate 90 percent confidence interval in Excel. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative.

Moreover, you are very welcome to comment here if you have any further questions or recommendations.

And, visit **ExcelDemy** to learn about many more Excel problem solutions, tips, and tricks. Thank you!