7) Use your Excel workbook to find the following expected value and standard deviations. a) The payout for Powerball on certain days. Thanks to Bill Durango(httpsww.bill.com/albs.html) for having the probabilities so that I didn't have to do them myself! Use the payout and probability columns in your Excel workbook. Result Jackpot! (5 balls and powerball) 5 balls and no powerball 4 balls and powerball 4 balls and no powerball 3 balls and powerball 3 balls and no powerball 2 balls and powerball 1 balls and powerball 1 balls and no powerball Loss Payout (in S) SEE BELOW 1,000,000 50,000 100 100 7 0.001725 7 0.001426 4 0.01087 4 0.02609 -1 0.959791 Note-the jackpot changes based on # of purchased tickets before there's a jackpot winner. 1. On 1/13/16, the winning jackpot was $1,586,000,000 2. On 10/23/18, the winning jackpot was $1,537,000,000 3. On 1/2/21, the winning jackpot was $1,005,000,000 4. On 3/27/19, the winning jackpot was $768,400,000 Probability 0.000000003422 0.00000008556 0.000001095 0.00002738 0.00006899 5. On 8/23/17, the winning jackpot was $758,700,000