CONFIDENCE function
Summary
Returns the confidence interval for a population mean
Syntax
CONFIDENCE(alpha,standard_dev,size)
The CONFIDENCE function syntax has the following arguments:
• Alpha Required. The significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
• Standard_dev Required. The population standard deviation for the data range and is assumed to be known.
• Size Required. The sample size.
• Alpha Required. The significance level used to compute the confidence level. The confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05 indicates a 95 percent confidence level.
• Standard_dev Required. The population standard deviation for the data range and is assumed to be known.
• Size Required. The sample size.
Example
=CONFIDENCE(A2,A3,A4)