Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

CONFIDENCE

Returns the confidence interval for a population mean, using a normal distribution.

Sample Usage

CONFIDENCE(0.05,1,20)
CONFIDENCE(A2,A3,A4)

Syntax

CONFIDENCE(alpha, standard_deviation, size)

  • alpha - The significance level used to compute the confidence level.
  • standard_deviation - The standard deviation of the population.
  • size - The size of the population.

 

Examples

CONFIDENCE(0.05,1,20) returns 0.43826, the confidence interval for the mean of a population based on a sample size of 20, with a 5% significance level and a standard deviation of 1.

 

Notes

  • The confidence level equals 100*(1-alpha)%. An alpha of 0.05 indicates a 95 percent confidence level. 
  • You can use CONFIDENCE or CONFIDENCE.NORM to perform this function.