How to use the CONFIDENCE function
Author: Oscar Cronquist Article last updated on May 11, 2022
The CONFIDENCE function calculates the confidence interval for a population mean, using a normal distribution.
Formula in cell B6:
=CONFIDENCE(B3, C3, D3)
Excel Function Syntax
CONFIDENCE(alpha, standard_dev, size)
Arguments
| alpha | Required. The significance level used to calculate the confidence level. 0.05 represents a 95% confidence level. |
| standard_dev | Required. The standard deviation for the data points. |
| size | Required. The number of data points. |
Comments
The CONFIDENCE function returns an #VALUE! error if an argument is not a number.
The CONFIDENCE function returns an #NUM! if alpha is less than 0 (zero) or more than 1.
Functions in 'Compatibility' category
The CONFIDENCE function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form