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