WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Confidence Interval In Excel

Confidence Interval In Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Confidence Interval in Excel?

Confidence Interval in excel is the range of population values that our true values lie in. This takes the CONFIDENCE value which is centered around the population mean of the range of values. So, by calculating the CONFIDENCE value, we can easily construct the confidence interval value around the average mean of the sample values.

CONFIDENCE is a statistical function in excel that uses the mean value of the sample data, a standard deviation of the sample, and the number of samples to calculate the confidence value to construct confidence interval value.

Confidence Interval In Excel 1

Syntax

Below is the syntax of the CONFIDENCE function.

Confidence Interval In Excel Syntax

  • Alpha: This is the sign which is at 1 confidence level; if 90% is the confidence level, then significance level 0.10.
  • Standard Deviation: This is the SD of the data range.
  • Size: The number of observations in the data set.

To compare the confidence interval value, we need to further calculate the mean of the data set. We will see some of the examples to understand practically.

How to Calculate & Find Confidence Interval in Excel?

Below is an example of calculating the confidence interval in excel.

You can download this Confidence Interval Excel Template here – Confidence Interval Excel Template

One of the food delivery company conducted a survey on delivering the food to the customer on numerous occasions, and they have recorded the time taken each time to deliver the food to the customer.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Solution

Below is the sample data of the same.

Confidence Interval In Excel Example 1

From the above data, we need to solve the confidence interval time to deliver the food quickly. Follow the below steps to calculate the confidence value.

  • Step 1: Copy the above data to the excel worksheet first.

Confidence Interval In Excel Example 1

  • Step 2: From the above data, we need to calculate certain values that are essential for the CONFIDENCE function in excel. So, the first thing we need to calculate is the MEAN value. So to calculate the mean value using the AVERAGE in excel function.

Confidence Interval In Excel Example 1.1

So, the average time is taken to deliver the food on 10 occasions in 52 Minutes.

  • Step 3: Calculate Standard Deviation of the data set by using the STDEV.P function.

Confidence Interval In Excel Example 1.2

  • Step 4: Now, we need to note down what is the confidence level of the food delivery company to commit themselves to deliver the food quickly. Let’s says they are committing at a 95% confidence level; then, we need to calculate the significance value.

Significance value will be 1 – Confidence Value = 5% i.e. 0.05

Confidence Interval In Excel Example 1.3

  • Step 5: The final part we need to note down is what is the number of occasions the experiment has been conducted, in this case, ten times.

Confidence Interval In Excel Example 1.4

Using these values, we will calculate the CONFIDENCE value.

  • Step 6: Open CONFIDENCE function in E6 cell.

Example 1.5

  • Step 7: The first argument of this function is Alpha i.e., what is the significance value. So our significance value is 0.05, which is there in cell E4.

Confidence Interval In Excel Example 1.6

  • Step 8: Next up is the “Standard Deviation” of the sample data. We have already calculated this SD in cell E3, so give the cell reference.

Example 1.7

  • Step 9: Final argument of the CONFIDENCE function is “Size,” i.e., the number of experiments conducted, so give cell reference as E5 cell.

Confidence Interval In Excel Example 1.8

  • Step 10: Ok, that’s all. Close the bracket and hit the enter key to get the confidence value.

Example 1.9

So, the confidence value of the data series is 8.30; using this, we can construct a confidence interval value.

Confidence Interval value is arrived by adding and subtracting the confidence value from the MEAN of the data set.

So, Confidence Interval (CI) = MEAN ± Confidence Value.

Example 1.10

  • CI = 52 ± 8.30
  • CI = 52 + 8.30 or 52 – 8.30
  • CI = 44.10 to 60.70.

Things to Remember Here

  • Confidence Interval in Excel is the plus or minus value of the average of the data set and the confidence value.
  • The confidence function accepts only numerical values.
  • In recent versions, CONFIDENCE function in excel is upgraded to CONFIDENCE.NORM & CONFIDENCE.T functions.

Recommended Articles

This has been a guide to Confidence Interval In Excel. Here we discuss how to calculate confidence interval value in excel using the confidence function with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Variance vs Standard Deviation
  • Calculating Return on Investment in Excel
  • Excel Carriage Return
  • Linear Regression Examples
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Confidence Interval Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More