Here is the description from Excel Help;
CONFIDENCE(alpha,standard_dev,size)

Alpha is the significance level used to compute the confidence level. The
confidence level equals 100*(1 - alpha)%, or in other words, an alpha of 0.05
indicates a 95 percent confidence level.

Standard_dev is the population standard deviation for the data range and
is assumed to be known.

Size is the sample size.
_______________________________________________

Third parameter (sample size) has to be a positive integer.
Second parameter being Standard Deviation, is by definition, positive
First parameter, being the confidence level has to be between 0 and 1...

How and why do you have a range in your formula?

"Eric" wrote:

Does anyone have any suggestions on how to use confidence with a list of
number between 1 number =0? It seems to me that confidence cannot work
with number below 1.
0.23 0.25 0.16 0.18 0.19 ...
CONFIDENCE(0.05,2,AV1:AV500)
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric