COINS AND CARDS USING A SPREADSHEET (30 points)

Objective:  To perform some experimental probability  experiments  using random numbers and 
			compare those results to theoretical probabilities.

Step 1: Start MS Excel

Step 2: Make three worksheets (excel defaults to 3 worksheets)

Label these worksheets: SHUFFLE, COINS, FACTORIAL

Step 3: SHUFFLE worksheet

Copy the names of the cards in column b (look below to find the names of the cards)
Then copy this formula in a1 "=RAND()". Don't use the quotes" 
Fill this function down to match the 52 card name.

Step 4: COINS worksheet 
Type in this text starting at A1.

4 COINS	5 COINS	6 COINS	
1	0	0		
0	0	1		
1	1	0		
1	1	1		
	0	0		
		1		
control + "=" calculates a new random number

Every place you see a "0" or a "1" type in this function "=TRUNC(RAND()+0.5)"

Step 5: FACTORIAL worksheet
Type the following text.  Notice the function. Start in A1
X	X! (X FACTORIAL)
1	=FACT(A2)
2	=FACT(A3)
3	=FACT(A4)
4	=FACT(A5)
5	=FACT(A6)
6	=FACT(A7)
7	=FACT(A8)
8	=FACT(A9)
9	=FACT(A10)
10	=FACT(A11)
20	=FACT(A12)
30	=FACT(A13)
40	=FACT(A14)
50	=FACT(A15)
52 =FACT(A16)

If you know how to fill down you can save your self some time.

Step 6:  Get the worksheet from C. Coleman and get directions from CC on 
			how to get the spreadsheet to work. CC will demonstrate.

Step 7: Turn in the worksheet.

HERE ARE TH NAMES OF THE CARDS

ACE OF SPADES
KING  OF SPADES
QUEEN OF SPADES
JACK OF SPADES
10 OF SPADES
9 OF SPADES
8 OF SPADES
7 OF SPADES
6 OF SPADES
5 OF SPADES
4 OF SPADES
3 OF SPADES
2 OF SPADES
ACE OF CLUBS
KING  OF CLUBS
QUEEN OF CLUBS
JACK OF CLUBS
10 OF CLUBS
9 OF CLUBS
8 OF CLUBS
7 OF CLUBS
6 OF CLUBS
5 OF CLUBS
4 OF CLUBS
3 OF CLUBS
2 OF CLUBS
ACE OF HEARTS
KING  OF HEARTS
QUEEN OF HEARTS
JACK OF HEARTS
10 OF HEARTS
9 OF HEARTS
8 OF HEARTS
7 OF HEARTS
6 OF HEARTS
5 OF HEARTS
4 OF HEARTS
3 OF HEARTS
2 OF HEARTS
ACE OF DIAMONDS
KING  OF DIAMONDS
QUEEN OF DIAMONDS
JACK OF DIAMONDS
10 OF DIAMONDS
9 OF DIAMONDS
8 OF DIAMONDS
7 OF DIAMONDS
6 OF DIAMONDS
5 OF DIAMONDS
4 OF DIAMONDS
3 OF DIAMONDS
2 OF DIAMONDS