Confidence Interval
Confidence interval is a calculation of values that describes the certainty or uncertainty of an estimate made on the analysis.
- allows us to identify how confident we are that our estimate represents the sample or population on which our analysis focuses
- can be subjective
- no set percentage that indicates a good level of confidence
- most analysts strive for a 95% confidence interval
- means we are 95% confident in the results of our analysis
- most analysts strive for a 95% confidence interval
How to Calculate a Confidence Interval
- CONFIDENCE function in Excel
- choose a confidence level (e.g., 95%)
- identify the number of records (n)
- calculate or input the standard deviation
- Alpha in the function above is set to 0.05 because we want to be within 95%
