To play the Powerball lottery game a player pays two dollars

To play the Powerball lottery game a player pays two dollars for the privilege of selecting five numbers (1-59) and one Powerball number (1-35). The players numbers are then matched against a drawing to determine winnings. In the drawing, five white balls are drawn out of a drum with 59 consecutively numbered balls (1-59), without replacement (that is, the balls are not returned to the drum after they are drawn), and one red ball is drawn out of a drum holding 35 consecutively numbered red balls (1-35). The following table shows the different ways to win: In your spreadsheet, create a table that calculates the probability of winning each of the prizes. Also calculate the odds of winning each prize. The odds are expressed with phrases such as 1 in 10,000\". The second number comes from dividing 1 by the probability you calculated. For example, if the probability of something is.10 the odds are 1 in 10\". Try to use a formula, using the & operator, to produce the phrase for the odds.

Solution