Topic_6_DQ_2

.xlsx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

DQ2

Subject

Mathematics

Date

Feb 20, 2024

Type

xlsx

Pages

7

Uploaded by DoctorWorldIbex30

Report
Excel Skills Learned Upon completing the sheet, you should have an understanding of: 1. Use the counting formulas =COMBIN(n,m) and =PERMUT(n, m) Math Skills Learned 2. How to compute probabilities for events using counting. 3. How to convert probabilities into odds. Instructi tasks ind indicate sheet is 1. When to use permutations, P(n,m) or =PERMUT(n,m) and/or combinations, C(n,m) or =COMBIN(n,m). V
tions : Open the tab labeled "Games" and complete the dicated there. Start by entering your name where ed. Pay attention to the legend and note that the self-checking. Video on counting
Game This is a self grading sheet for columns B, D, F, and G. If your answer is correct it will show green , else you will see red . 35 horses ran in the Kentucky Derby. The Exacta bet involves picking the first two finishers in order. Determine the number of outcomes for two horses finishing in the first two spots and the probability of winning the Exacta bet if you pick the horses at random. 35 horses ran in the Kentucky Derby. The Superfecta bet involves picking the first four finishers in order. Determine the number of outcomes for four horses finishing in the first four spots and the probability of winning the Superfecta bet if you pick the horses at random. In a lottery game, 50 numbered ping-pong balls are put in a bin, and 4 are randomly chosen. To win the jackpot, you need to match all 4 numbers in the order in which they were drawn. Determine the number of outcomes for picking 4 different numbers in order from the 50 ping- pong balls and the probability of you picking the correct numbers in order. In a lottery game, 40 numbered ping-pong balls are put in a bin, and 5 are randomly chosen. To win the jackpot, you need to match all 5 numbers. Determine the number of outcomes for picking 5 different numbers from the 40 ping-pong balls and the probability of you picking the correct numbers. In a lottery game, 40 numbered ping-pong balls are put in a bin, and 5 are randomly chosen. You’ll get twice your money back if you match exactly three of the five numbers. Still using the same number of outcomes as the game above (choosing 5 different ping-pong balls from the 40), determine the probability of matching three out of five numbers. 35 horses ran in the Kentucky Derby. The Trifecta bet involves picking the first three finishers in order. Determine the number of outcomes for three horses finishing in the first three spots and the probability of winning the Trifecta bet if you pick the horses at random.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help