CONFIDENCE
Name
Confidence
Description
Returns confidence interval for a population mean.
Syntax
CONFIDENCE(alpha,stdev,size)
| 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 Type
Accepts numeric data for all arguments. Returns numeric data.
Example
CONFIDENCE(0.5,B4,D5)
CONFIDENCE(0.5,R4C2,R5C4)