Buzz
The CONFIDENCE function returns the confidence interval of the population mean using normalized distribution. This confidence interval is a range of values. You need to know the sample size, the standard deviation of the population, and the significance level when using this function for computation.
The CONFIDENCE function returns the confidence interval
Guide to using the CONFIDENCE function in Excel - Illustrated Examples
Syntax: CONFIDENCE(alpha,standard_dev,size)
Where:
- Alpha : Required – Represents the significance level used to calculate the confidence level. Confidence level will be 100*(1 - alpha)%.
- standard_dev : Required – The standard deviation of the population for the data range and is assumed to be known.
- Size : Required – The sample size
Example:
Input your real values into Excel corresponding to the function parameters in the Excel cells. In this example, we calculate with the following parameter values: Significance level is 0.08, Standard deviation of the population is 3, and Sample size is 40:
Enter the formula at cell C9. The calculated result of the function is 0.830423318:
Now you know how to use the CONFIDENCE function in Excel. This is a highly effective data evaluation tool. Make sure to input the sample size as an integer to ensure accurate computation. You can apply this function across Office 2013, Office 2010, Office 2007, and Office 2003 versions.
