Excel Function : CONFIDENCE
Category
Compatibility
Description
Returns the confidence interval for a population mean
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CONFIDENCE-function-75ccc007-f77c-4343-bc14-673642091ad6
Syntax and Description of the CONFIDENCE Excel Function
in excel The CONFIDENCE function in Excel returns the confidence interval for a population mean, using a normal distribution. The syntax for the CONFIDENCE function is: CONFIDENCE(alpha, sigma, n) where: alpha: is the significance level. sigma: is the population standard deviation. n: is the sample size.
About CONFIDENCE Excel Function
CONFIDENCE returns the confidence interval for a population mean. The confidence interval is a range of values that is likely to include the population mean. The confidence level is the likelihood that the confidence interval contains the population mean. For example, a 95% confidence level means that there is a 95% chance that the confidence interval contains the population mean.