Help reproducing the table from SSB p.124 in Excel?

[climber]

I'm reading Sharp Sports Betting and trying to follow along in Excel to make sure I am getting all the concepts as I go.

p.124 features Table 4 titled: "Rarity of Good W-L Records"

4 columns are: (sample size, 1:100, 1:1000, 1:10000)
the values in the 3 probability columns are the W-L records needed to reach that column's specified level of significance with the given sample size.

I was looking at the BINOMDIST function to generate these values but was unsure how to use it as I am essentially attempting to solve for the function's first input.

I can obviously use Solver to get the needed number of wins one cell at a time but was hoping someone here could show me the right way to do this in a standard formula.

Thanks

[climber]

paging Ganchrow...

paging Ganchrow...

[Sinister Cat]

I think this does it (change the "90" to whatever sample size, change the last number for each of the other three columns):

1+CRITBINOM(90,0.5,0.99)

[Ganchrow]

Sinister Cat has basically got it right.

See attached spreadsheet.

[climber]

awesome. thx guys--figured there would be some function i'd never heard of that would handle it.