spot_img

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
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR