View Single Post
Old 01-25-2009, 08:19 PM   #23
climber
old hand
 
Join Date: Sep 2004
Location: retired to the burbs w/ a salary
Posts: 1,368
Re: Did i just waste $13 buying SSB?

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.

Thanks.
climber is offline   Reply With Quote