How to calculate 95 Confidence interval in Google Sheets and Excel

A confidence interval is the range of values that make up the population mean. Google Sheets and Excel are vital tools for calculating any dataset’s confidence interval. This article will discuss some of the workarounds of calculating confidence levels.

To calculate the 95 Confidence interval in Google Sheets

Steps:

1. Visit the Google account and log in using your email detail (That is, https://www.google.com/account).

2. From Google Apps, click on the Sheets icon and select the existing Sheet.

3. Enter the dataset you want to calculate the confidence interval in the empty cells.

4. Next, calculate the mean of your dataset.

Click on an empty cell and name it Average, and then locate the cell next to this, and type =AVERAGE (

Choose all the cells that contain your dataset, and close the bracket.

Finally, hit the Enter button.

5. Then, calculate the Standard Deviation on the dataset.

Click on an empty cell and name it STDEV, and then locate the cell next to this, and type =STDEV (

Choose all the cells that contain your dataset, and close the bracket.

Finally, hit the Enter button.

6. Next, count the number of items in your Sheet and store them in cell n. That is type =COUNT( cells). Then, hit the Enter button.

7. Choose another cell that will hold the confidence interval of the data.

Formula: =TINV (1-.95, n-1)*STDEV/SQRT(n)


8. Finally, hit the Enter button.

To calculate the 95 Confidence interval in Excel

Steps:

1. Open the Excel document you want to calculate the Confidence interval.

2. Enter the dataset you want to calculate the confidence interval in the empty cells.

3. Next, calculate the mean of your dataset.

Click on an empty cell and name it Average, and then locate the cell next to this, and type =AVERAGE (

Choose all the cells that contain your dataset, and close the bracket.

Finally, hit the Enter button.

4. Then, calculate the Standard Deviation on the dataset.

Click on an empty cell and name it STDEV, and then locate the cell next to this, and type =STDEV (B2:B7)

Choose all the cells that contain your dataset, and close the bracket.

Finally, hit the Enter button.

5. Next, count the number of items in your Sheet and store them in cell n. That is type =COUNT( cells). Then, hit the Enter button.

7. Choose another cell that will hold the confidence interval of the data.

Formula: =TINV (1-.95, n-1)*STDEV/SQRT(n)


8. Finally, hit the Enter button.


Leave a Comment