CONFIDENCE.NORM Function Explained
The CONFIDENCE.NORM Function in Microsoft Excel calculates the confidence interval for a population mean, assuming a normal distribution, given a sample size and a confidence level. It takes three arguments: alpha, standard_dev, and size. Alpha is the significance level used to compute the confidence level (e.g. 0.05 for 95% confidence level). Standard_dev is the population standard deviation. Size is the sample size. The function returns the confidence interval for the population mean.
CONFIDENCE.NORM Function Syntax
CONFIDENCE.NORM(alpha,standard_dev,size)
- alpha: The significance level used to compute the confidence level. It must be a number between 0 and 1.
- standard_dev: The population standard deviation for the data range and is assumed to be known.
- size: The sample size.