CONFIDENCE.NORM

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

Sample Usage

CONFIDENCE.NORM(0.05,1.6,250)

CONFIDENCE.NORM(A2,A3,A4)

Syntax

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

  • alpha - One minus the desired confidence level. E.g. 0.1 for 0.9, or 90%, confidence.

  • standard_deviation - The standard deviation of the population.

  • pop_size - The size of the population.

Notes

  • CONFIDENCE.NORM calculates the width of half the confidence interval such that a value picked at random from the data set has 1-alpha probability of lying within the mean plus or minus the result of CONFIDENCE.NORM.
  • You can use CONFIDENCE or CONFIDENCE.NORM to perform this function. 

See Also

ZTEST: Returns the one-tailed P-value of a Z-test with standard distribution.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
11830459542507112347
true
Search Help Center
true
true
true
true
true
35
false
false