Skip to main content

CONFIDENCE

Definition:

This function returns confidence interval for a population mean.

Syntax:

CONFIDENCE(alpha,stdev,size)

Notes

Arguments

This function has these arguments:

ArgumentDescription
alphaAlpha, significance level used in calculating confidence level, where confidence level is 100 times (1-alpha)%
stdevPopulation standard deviation for the range
sizeNumber 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.


 

Step 1.  To begin to use CONFIDENCE formula, start with the Excellentable you would like to edit..



Step 2. Then type the CONFIDENCE formula into the cell you have chosen to display the outcome: 


Step 3. Excellentable will generate the outcome when hitting enter. 



Live Excellentable Example

A
B
C
1
Argument
Value
2
alpha
0.05
3
stdev
3.5
4
size
150
5
6
7
8
9
Result
Formula
10
0.560106363
CONFIDENCE(B2,B3,B4)


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.