

Step 2: Second, determine the sample size, that is, the number of observations in the sample. Step 1: Firstly, determine the sample mean based on the sample observations from the population data set. The formula for the Confidence Interval can be calculated by using the following steps: Lastly, the confidence interval at a 99% confidence level is 3.17 to 3.43.įrom the above illustration, the confidence interval of a sample spreads out with the increase in confidence level. Thus, the confidence interval at 98% confidence level is 3.18 to 3.42. Thus, the Confidence Interval at a 95% confidence level is 3.20 to 3.40.

Therefore, the Confidence Interval at a 90% confidence level is 3.22 to 3.38. The overall calculation for the Upper Limit and Lower Limit is given below. The confidence Interval is calculated using the following formula.Ĭonfidence Interval = ( x̄ – z * ơ / √n) to ( x̄ + z * ơ / √n) Determine the confidence interval for the following data. The survey was on a scale of 1 to 5, with 5 being the best, and the average feedback of the respondents was 3.3, with a population standard deviation of 0.5.

Let us consider the below example of 100 respondents surveyed for their customer service feedback.
#90 CONFIDENCE INTERVAL Z SCORE CALCULATOR DOWNLOAD#
You can download this Confidence Interval Formula Excel Template here – Confidence Interval Formula Excel Template Confidence Interval Formula – Example #1
