CONFIDENCE Function Explained
The CONFIDENCE Function in Microsoft Excel calculates the confidence interval for a population mean, based on a sample of numerical data. It takes three arguments: alpha, standard_dev, and size. Alpha is the significance level used to compute the confidence level, standard_dev is the population standard deviation, and size is the sample size. The function returns the confidence interval for a population mean.
CONFIDENCE Function Syntax
CONFIDENCE(alpha,standard_dev,size)
- alpha: The significance level used to compute the confidence level. Alpha must be greater than 0 and less than 1.
- standard_dev: The population standard deviation for the data range and is assumed to be known.
- size: The sample size.