How to use CONFIDENCE?

[Eric]

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

 

[Sheeloo]

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?

 

[David Biddulph]

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).