To get the Confidence Interval, we need the Mean and the Confidence Levelįigure 7 – How to find the 95% confidence interval.Notice that in Row 18, the result is Confidence level and not Confidence interval.Our confidence interval will be set at 95% and we will check the Summary statistics boxįigure 5 – How to calculate 95% confidence intervalįigure 6 – Result of Descriptive statistics
We will insert an Output range or check the New worksheet box for the result to be displayed in another worksheet. On the descriptive statistics dialog box, we will click Input range and select the range of values from Cell B4 to Cell B11.We will select Descriptive statistics and click OK Once we have clicked Data Analysis, we will see the Data Analysis dialog box.We will check the Analysis Toolpak box and the Analysis Toolpak VBA boxįigure 4 – Inserting the Data Analysis tool.If we do not have the Data Analysis tool, we should do the following:.We will click the Data tab, and then, the Data Analysis tool.We will use figure 2 to illustrate how we can find the 95% confidence interval of a set of values.įigure 2 – How to calculate confidence interval.In this tutorial, we will learn the easy way of calculating confidence interval.įigure 1 – Result of 95% confidence interval How to Find 95% Confidence Interval Confidence interval specifies a range of values where there is a probability that the true value of a parameter lies. We can apply the Descriptive Statistics tool to calculate confidence interval easily.