This function returns confidence interval for a population mean.
Syntax
CONFIDENCE(alpha,stdev,size)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| alpha | Alpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)% |
| stdev | Population standard deviation for the range |
| size | Number representing the size of the sample; if not an integer, the number is truncated |
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
CONFIDENCE(0.5,B4,D5)
CONFIDENCE(0.5,R4C2,R5C4)
CONFIDENCE(0.05,3.5,150) gives the result 0.560106363
Version Available
This function is available in product version 1.0 or later.
See Also
AVERAGE | CHITEST | Statistical Functions