CONFIDENCE.NORM

Formulas / CONFIDENCE.NORM
Calculate a confidence interval for a population mean using a normal distribution.
=CONFIDENCE.NORM(alpha, standard_dev, size)
  • alpha - the significance level used to calculate the confidence level
  • standard_dev - the standard deviation for the data set
  • size - the sample size

Examples

  • =CONFIDENCE.NORM(A2:A4, 0.95)

    The CONFIDENCE.NORM function computes a confidence interval for the population mean based on a sample of data.

Summary

The CONFIDENCE.NORM function calculates a confidence interval for a population mean using a normal distribution. As an example, it can be used to estimate the probability of the next package taking a delivery time within the confidence interval.

  • The CONFIDENCE.NORM function calculates a confidence interval for a population mean, which is a range of values that includes the population mean and is the sample mean plus one standard deviation.
  • The CONFIDENCE.NORM function uses a normal distribution to calculate the confidence interval.

Frequently Asked Questions

What Does the CONFIDENCE.NORM Function Do?
The CONFIDENCE.NORM function calculates a confidence interval using a normal distribution. The confidence interval is a range of values that uses a normal distribution to calculate the confidence interval.
What Can You Infer From the Confidence Interval?
The confidence interval does not allow the analyst to infer that there is probability 1 - alpha that the next package will take a delivery time that is in the confidence interval.
What Happens if Standard_Dev is Less Than 0?
The CONFIDENCE.NORM does not return the #NUM! error if standard_dev is less than 0.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.