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?
|