You appear still to be somewhat confused.
The second parameter of the CONFIDENCE function is the standard deviation.
It cannot be 2 if your data values are all between 0 and 1. Its value
should be STDEV(AV1:AV500) if that's the range which contains your samples.
The third parameter is the sample size, so in your case it would be 500, or
COUNT(AV1:AV500).
--
David Biddulph

"Eric" wrote in message
...
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