How To Calculate Confidence Interval In Excel Application?

This is a function that will return with the confidence interval, using the average of a population, based on a normal distribution. The calculation requires having data that looks like this:

 

dataClick on an empty cell (1), and type in the confidence formula which is=CONFIDENCE(A2; A3 ;A4) (2).

CONFIDENCE formula

Note: The 0,23 is the alpha, while the 3,7 is the standard deviation and the 80 would be the commuters, which is an example of the size.

Template

You can download the Template here – Download

RELATED ARTICLESMORE FROM AUTHOR