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

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

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