View Single Post
Old 01-29-2009, 01:53 PM   #24
Join Date: Dec 2002
Posts: 400
Re: Did i just waste $13 buying SSB?

Originally Posted by climber View Post
Just got in the mail the other day. I'm on page 131 right now.

If anyone can tell me how to replicate the table on page 124 using Excel I'd be grateful.

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 tell me an easier way to do this in a standard formula.


I must admit I am impressed you got this far.

99% of people who bet sports don`t even think about this stuff.

Maybe my "grumpy" post was just the kick up the ass you needed.

Dreamer is offline   Reply With Quote