How to Calculate 90 Percent Confidence Interval in Excel

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.


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.

CONFIDENCE Function Syntax

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.

Sample Dataset to Calculate 90 Confidence Interval in Excel

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.

Calculate the Mean of Your Dataset

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)

Calculate the Standard Deviation of Your Dataset

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.

Declare Significance Level to Calculate 90 Confidence Interval in Excel

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

Put the Size Value of Your Dataset

  • Afterward, click on the F8 cell and insert the following formula.
=CONFIDENCE(F6,F5,F7)
  • Subsequently, hit the Enter button.

Use the CONFIDENCE Function to Calculate 90 Confidence Interval in Excel

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,"##,##.##")

Show the 90 Confidence Interval in a Cell

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

Calculated 90 Confidence Interval in Excel

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!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo