View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mk9999999 mk9999999 is offline
external usenet poster
 
Posts: 2
Default calculating probabilty of x number of successes with multiple tria


how do i calculate the probability of a certain number of successes when
there are multiple trials each with different probabilities e.g.

Trial P (of success)
1 0.2
2 0.4
3 0.9
4 0.6
5 0.5
6 0.4
7 0.7
8 0.3
9 0.1
10 0.5
11 0.6
12 0.7
13 0.9
14 0.1
15 0.2
16 0.2
17 0.2
18 0.5
19 0.6
20 0.7
21 0.9

How would i calculate the probability of 10 successes for example?

I could calculate it manually, but there must be a quicker way of doing it
using excel?

cheers