MAT 144 Grand Canyon University Technology Question

I’m working on a mathematics multi-part question and need a sample draft to help me understand better.

For this DQ, you’ll complete a modified version of Technology Assignment 1 in Lesson 3-3 of the textbook in ALEKS, for which you’ll calculate the probabilities of various games of chance, using permutations (selection of items when the order matters) and combinations (selection of items when order does not matter).

Download the attached template (“QR 3-3 Tech Template MODIFIED.xlsx”) and follow these steps (note that the ALEKS video for the template may not help that much):

1. For each game described in column A, indicate in column B whether this involves permutations (selection of items where the order of selection matters) or combinations (where the order of selection does not matter). Enter either “Permutation” or “Combination”.
2. In column C, provide a short description, based on the game information in column A, of the number of outcomes for the game (i.e., different possible ways in which the game could come out).
3. In column D, use either the Excel PERMUT() function or the Excel COMBIN() function to calculate the number of outcomes for the game.
4. In column E, describe what you would have to do to win this game.
5. In column F, enter the number of ways in which you can win. Note that these will all be simple number entries except for the last game, which requires a bit more consideration; for that last game, see the hint in the text box below the table.
6. In column G, calculate the probability of winning, which will be =(# of ways to win)/(total # of outcomes). You must use Excel formulas here.
7. Finally, in column H, calculate the odds against winning, which is given by:

(odds against) = (1 – probability of winning) / (probability of winning)

The entries for the first game are filled in for you; feel free to use these as a model for your other entries.

MAT-144 T5 DQ2 Explanation – YouTube