Thread: Strike Rates!
View Single Post
  #7  
Old 11th January 2005, 07:28 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default Losing runs

To find your longest losing run of losses to a 99% confidence level do as follows;

=sum(1-(Losing % ^(to the power of) N (N=number of Losses) this will provide a % when you get to 99% this should equate to your longest losing run

example win%= .092 Losing % .908

=sum(1-(.908^5losses)=.382
=sum(1-(.908^17losses)=.806

Cheers
Reply With Quote