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

Error.

User does not have sufficient privileges to access this Content
Learn More