Excel Function : CONFIDENCE

Download now!

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.