Alan (or anyone whom believes the answer to the question/bet as proposed in the first post is 1/6) could you please explain what is wrong with
OnceDear's Excel spreadsheet?
I know there are a number of simulations out there…but I feel most should understand Excel.
I’m aware that Alan wrote…
But I’m not seeing how it’s not responding to the question. The spreadsheet picks two numbers from 1 to 6 (aka roll two dice). Then, it shows that when at least one of them is a 2 that both of them will be a 2 about 1/11 of the time. This IS the question.
So please, explain how his spreadsheet does not represent the question/bet.