Test 1 version 2 part d

24 views2 pages
Part C [10 points]
Use only the data shown to answer the following questions.
All ranges have been named using the labels that appear in the worksheets.
Recall from Test 1 that the graphic below is
from a workbook to analyze probability in
card games.
This section “deals” cards.
S_ is one of the integers 1, 2, 3, or 4, and is
randomly chosen.
Suit is assigned by an IF statement according
to the corresponding value of S_.
1 - Clubs
2 - Diamonds
3 - Hearts
4 - Spades
R_ is an integer in the range 2 to 14
inclusive, also randomly chosen.
Rank is assigned by an IF statement
according to R_, using the following
mapping:
Values in the range 2 to 10 are copied
from R_
11, 12, 13, and 14 are replaced by “Jack”,
“Queen”, “King”, and “Ace”
The formula in Card assembles Rank and
Suit into the name as shown.
1) Write a formula for Rank that does NOT use an IF function.[4]
= LOOKUP( R_, R_value, AssignRank)
2) In general, why is this not a good way to “deal cards”? [1]
Limit your answer to ONE SENTENCE.
It produces duplicates.
xcards2
R_value AssignRank
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
10 10
11 Jack
12 Queen
13 King
14 Ace
S_value AssignSuit
1 Clubs
2 Diamonds
3 Hearts
4 Spades
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Grade+

Unlimited access to all notes and study guides.

Grade+All Inclusive
$10 USD/m
You will be charged $120 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.