The Excel function: CONFIDENCE
Syntax
CONFIDENCE(alpha,standard_dev,size)
The CONFIDENCE function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- 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.