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

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%