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).


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.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell