Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is Excel calculating a number? | Excel Discussion (Misc queries) | |||
Calculating Time with a number value | Excel Worksheet Functions | |||
Probabilty - Binomial - a simulation game? | Excel Worksheet Functions | |||
Text number to number value for calculating | Excel Worksheet Functions | |||
Calculating number of days | Excel Worksheet Functions |