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

CONFIDENCE.NORM

Calculates the width of half the confidence interval for a normal distribution.

Sample Usage

CONFIDENCE.NORM(0.3,2,20)
CONFIDENCE.T(A2,A3,A4)

Syntax

CONFIDENCE.NORM(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.NORM(0.05,1,20) returns 0.4635, 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.