View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default calculating probabilty of x number of successes with multipletria

On Jan 8, 5:43*pm, I wrote:
Took less than 2.4 seconds for the UDF to sum the
probability of exactly 10 successes over all combinations. *Of course,
YMMV depending on the speed of your system. *Took 5-10 minutes to
write the VBA UDF.


Reduced to about 0.9 seconds with a "tedious", but obvious
optimization. Makes the program look less "elegant". Add 2-3 minutes
to the development time ;-).