View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cwbecker
 
Posts: n/a
Default Confidence Interval

The individual CONFIDENCE() function [CONFIDENCE(alpha, STDEV, n)] returns a
different confidence interval than if you use Descriptive Statistics Analysis
[ToolsData AnalysisDescriptive Statistics]. In fact, I've been witnessing
a 25% difference between the two values.
Any ideas why these two methods of calculating the confidence interval yield
different results?