Probability that its a 1:
=COUNTIF(A2:A8,1)/COUNTA(A2:A8)

Similarly, the probability that its a zero:
=COUNTIF(A2:A8,0)/COUNTA(A2:A8)

Alternatively, since Pzero + Pone = 1
as the data comprises only zeros or 1s (in this instance)
Pzero = 1 - COUNTIF(A2:A8,1)/COUNTA(A2:A8)

any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Raul Sousa" wrote:
I am trying to calculate probabilities in excel but I dont really know which
functions to use.
Lets say I have only two possible outcomes 1 and 0. So far the outcome was
as follow:
1
0
1
0
1
1
1

Which are the odds to get 1 and to get 0?
Which formula can calculate this?