Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/02/Confidence-Intervals.xlsx

In this video I demonstrate how to calculate a confidence interval based on a 95% confidence level. The confidence level can be changed to any value.

There are two methods for doing this:

Table of Contents:

00:00 - Introduction
00:11 - The Analysis ToolPak method
02:11 - The CONFIDENCE.T function method (also using AVERAGE, STDEV.S and COUNT)
------------------------