The hypergeometric function in Excel lets you compute the probabilities of matching one to five numbers in the first part of the Powerball drawing.
Suppose your favorite number is seven. What is the probability that it appears in the sample of five taken at random from a field of 69, as it did on November 15?
Using Excel’s nomenclature, the number of successes in the sample would be one, the sample size would be five, the number of successes in the population would be one, the population size would be 69 and the cumulative argument would be set to false.
The result is approximately .072, about 7.2%. The probability that seven does not appear would be 1 – .072 = .928 or 92.8%.
What is the probability of matching all five numbers? Change the number of successes in the sample to five and the number of successes in the population to five.
The result is almost zero, .000000089, or 1 in 11,238,513.
Unfortunately, Excel does not have a function for computing the probability of the advocates telling the truth about PZP in 2026, that you can’t use the pesticide for “humane population reduction” without sterilizing the mares.
RELATED: Probabilities and Possibilities for 2026.
► Get the truth about wild horses and the wild horse advocates at westernhorsewatchers.com.
Western Horse Watchers Association 