The** confidence interval** is a very important statistical parameter. It gives a proper insight into how precise a data survey is. This allows users to validate their data properly. * Excel* provides two easy ways to calculate the confidence interval. In this article, we will show how to calculate

*confidence interval in*

**99***.*

**Excel**## Download Practice Workbook

You can download the practice workbook here.

## What Is Confidence Interval?

Confidence interval in statistics refers to a range between which the value of a surveyed parameter will fall. 99% confidence interval means * 99* out of

*values will fall within that confidence interval and only*

**100***will fall over or below that range. For example, if we survey a population for their height and the average height being*

**1%***meters with*

**1.7***confidence level and the confidence interval being*

**99%***to*

**1.68***, then in*

**1.72***out of*

**99***surveys the average value will fall between*

**100***and*

**1.68***.*

**1.72**## 2 Easy Ways to Calculate 99 Confidence Interval in Excel

In this article, we will show 2 handy ways to calculate 99 confidence interval in Excel. Firstly, we will use * the CONFIDENCE function* to calculate the interval. Then, we will apply

**the Data Analysis***option to do so.*

### 1. Using CONFIDENCE Function

* The CONFIDENCE function* is a statistical function. This takes in the significance level (alpha), standard deviation, and sample size as the argument to return the confidence interval for a mean of a sample dataset.

**Steps:**

- To begin with, select the
cell and type the following,**F5**

`=1-F4`

- Then, hit
.**Enter**

- As a result, we will get the value of alpha.
- After that, select the
cell and write down,**F6**

`=AVERAGE(C5:C10)`

- Hit
.**Enter**

- Consequently, we will get the mean of the data.
- Then, choose the
cell and enter the formula below,**F7**

`=STDEV(C5:C10)`

- Press
.**Enter**

- Consequently, we will get
**the standard deviation**of the dataset. - Afterward, select the
cell and type,**F8**

`=CONFIDENCE.T(F5,F7,6)`

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

We used * the CONFIDENCE.T function* instead of

*function because our data sample is very small and less likely to result in a normal distribution.*

**the CONFIDENCE.NORM**- As a result, we will have a margin of error for this data.
- Then, select the
cell and write the following formula below,**F9**

`=F6-F8`

- Press
.**Enter**

- Consequently, we will have a lower confidence level interval.
- Finally, select the
cell and type the following formula,**F10**

`=F6+F8`

- Hit
.**Enter**

- Finally, we will have the upper and lower confidence interval for our dataset.

**Read More: ****How to Calculate Confidence Interval for Population Mean in Excel**

### 2. Applying Data Analysis Option

* The Data Analysis* option is a tool that is a part of

*of*

**the Analysis Toolpak***. Here, we will make use of this tool to calculate the confidence interval for our dataset.*

**Excel****Steps:**

- Firstly, go to the
tab.**Data** - Then, select the
option from the**Data Analysis**group.**Analyze** - Consequently, a prompt will be opened.

- From the prompt, first, select the
option.**Descriptive Statistics** - Then, click on
.**OK**

- In the Descriptive Statistics prompt, first, select the input range of data from which you want to get the confidence interval.
- Here, we will choose the range
.**C4:C10** - Secondly, mark the
box**“Labels in first row”****.** - Thirdly, select the output range.
- In this case, it will be
.**E4:F19** - Then, mark the
box.**“Summary statistics”** - After that, set the
.**Confidence Level for Mean** - We will set it to
**99%.** - Finally, click
.**OK**

- Consequently, we will have a statistical summary of our data.

- After that, choose the
cell and write the following formula,**C12**

`=F6-F19`

- Hit
**Enter**.

- As a result, we will get a lower confidence interval for the data.
- Then, select the
cell and enter,**C13**

`=F6+F19`

- Press the
button.**Enter**

- Consequently, we will have the upper and lower confidence interval for our dataset.

**Read More: ****How to Calculate 90 Percent Confidence Interval in Excel**

## Conclusion

In this article, we have discussed * 2* methods to calculate

*confidence interval in*

**99***. These methods will allow users to interpret their data more accurately.*

**Excel****Related Articles**

**How to Make a Confidence Interval Graph in Excel (3 Methods)****Calculate P-Value from Confidence Interval in Excel****How to Calculate Z-Score with 95 Confidence Interval in Excel****Find Confidence Interval in Excel for Two Samples****Add Confidence Interval Error Bars in Excel****How to Calculate Confidence Interval Proportion in Excel****Linear Regression Confidence Interval in Excel (Calculation and Interpretation)**