Deming´s Red Bead.xlsx

The file simulates Deming´s experiment with red beads using the Monte Carlo method. Theoretically, the ratio of white and red beads is 4: 1, the average should be 10.0. But this is not the case for a huge number of experiments, although the sample was made each time using the random number method. Simulation refutes the claim that random selection is perfect. And mechanical or random selection produces similar results.