The CONFIDENCE function in Excel is used to calculate the confidence interval for a population mean, based on a sample mean, a standard deviation, and the size of the sample. However, please note that the CONFIDENCE function has been replaced by the newer CONFIDENCE.NORM function in Excel 2010 and later.
Here’s how to use the CONFIDENCE.NORM function:
Syntax
CONFIDENCE.NORM(alpha, standard_dev, size)
Parameters
- alpha: The significance level used to compute the confidence level. A common value for alpha is 0.05, which corresponds to a 95% confidence level.
- standard_dev: This is the standard deviation of the population; it must be a positive number.
- size: The size of the sample; it must be a positive integer.
Example
Suppose you want to calculate the confidence interval for a sample with:
- A population standard deviation of 2.5
- A sample size of 100
- A significance level of 0.05 (which corresponds to a 95% confidence level)
You would use the CONFIDENCE.NORM function as follows:
=CONFIDENCE.NORM(0.05, 2.5, 100)
This formula would return the margin of error that you can add and subtract from the sample mean to get the confidence interval.
Calculating the Confidence Interval
To construct the confidence interval, you need a sample mean (( bar{x} )). You compute the confidence interval as:
- Lower limit: ( bar{x} – text{Confidence Value} )
- Upper limit: ( bar{x} + text{Confidence Value} )
Tips
- Ensure that your population standard deviation and sample size are correctly calculated and input for accurate results.
- If you’re unsure about the difference between the CONFIDENCE function and CONFIDENCE.NORM, use CONFIDENCE.NORM for newer versions of Excel, as it is the updated function.
If you are using an older version of Excel that still uses the CONFIDENCE function, the syntax and usage are similar:
CONFIDENCE(alpha, standard_dev, size)
The formulas and methodology are essentially the same, with the function computing the same statistical concept.
Unlock Your Potential
Excel
Access
Power BI
