For computing a confidence interval, you need to have the mean, standard deviation, and the number of the sample (n). Using this formula, you could use Excel to compute the mean =SUM (A1:A7)/Count (A1:A7). Also, you could use this formula for finding Standard deviation = stdev(A1:A7) Now, let’s see the process of creating a confidence interval at 95%.

Leave Feedback