SheetFX
≡
<< Go back to all functions

CONFIDENCE.NORM

The CONFIDENCE.NORM function in Google Sheets calculates the width of half the confidence interval for a normal distribution. It is useful for estimating sample sizes required for confidence levels.

Function Syntax and Parameters

Syntax: CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

Parameters:

  • alpha: The desired significance level for the confidence interval. Typically, a value between 0 and 1.
  • standard_deviation: The standard deviation of the population.
  • pop_size: [Optional] The size of the population. If not provided, a large value will be presumed.

Step-by-Step Tutorial

  1. Using CONFIDENCE.NORM for sample size estimation:
    • Example: =CONFIDENCE.NORM(0.05, 10, 1000)
    • Result: 0.395

Use Cases and Scenarios

  1. Market Research: Determine the required sample size to estimate a parameter with a desired level of confidence.
  2. Quality Control: Calculate the confidence interval for a manufacturing process to determine the acceptable error range.

Related Functions

  • CONFIDENCE.T: Calculates the width of half the confidence interval for a Student's t-distribution.

Related Articles