Name______Answers____________
March 1, 2005 Homework
1. Consider a keno game in which there are 40 balls, the player picks 3 and the casino draws 10. Fill in the following table to determine the expected return.
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
3 |
COMBIN(10,3)*COMBIN(30,0) |
120 |
50 |
6,000 |
|
2 |
COMBIN(10,2)*COMBIN(30,1) |
1,350 |
2 |
2,700 |
|
1 |
COMBIN(10,1)*COMBIN(30,2) |
4,350 |
0 |
0 |
|
0 |
COMBIN(10,0)*COMBIN(30,3) |
4,060 |
0 |
0 |
|
Total |
9,880 |
8,700 |
Expected return = ___ 88.06%____________
2. Consider a keno game in which there are 64 balls, the player picks 4 and the casino draws 16. Fill in the following table to determine the expected return.
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
4 |
COMBIN(16,4)*COMBIN(48,0) |
1,820 |
180 |
327,600 |
|
3 |
COMBIN(16,3)*COMBIN(48,1) |
26,880 |
5 |
134,400 |
|
2 |
COMBIN(16,2)*COMBIN(48,2) |
135,360 |
1 |
135,360 |
|
1 |
COMBIN(16,1)*COMBIN(48,3) |
276,736 |
0 |
0 |
|
0 |
COMBIN(16,0)*COMBIN(48,4) |
194,580 |
0 |
0 |
|
Total |
635,376 |
597,360 |
Expected return = _____ 94.02%__________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
5 |
COMBIN(25,5)*COMBIN(75,0) |
53,130 |
100 |
5,313,000 |
|
4 |
COMBIN(25,4)*COMBIN(75,1) |
948,750 |
15 |
14,231,250 |
|
3 |
COMBIN(25,3)*COMBIN(75,2) |
6,382,500 |
3 |
19,147,500 |
|
2 |
COMBIN(25,2)*COMBIN(75,3) |
20,257,500 |
1 |
20,257,500 |
|
1 |
COMBIN(25,1)*COMBIN(75,4) |
30,386,250 |
0 |
0 |
|
0 |
COMBIN(25,0)*COMBIN(75,5) |
17,259,390 |
0 |
0 |
|
Total |
75,287,520 |
58,949,250 |
Expected return = _____ 78.30%__________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
6 |
COMBIN(14,6)*COMBIN(61,0) |
3,003 |
10000 |
30,030,000 |
|
5 |
COMBIN(14,5)*COMBIN(61,1) |
122,122 |
250 |
30,530,500 |
|
4 |
COMBIN(14,4)*COMBIN(61,2) |
1,831,830 |
25 |
45,795,750 |
|
3 |
COMBIN(14,3)*COMBIN(61,3) |
13,100,360 |
5 |
65,501,800 |
|
2 |
COMBIN(14,2)*COMBIN(61,4) |
47,488,805 |
0 |
0 |
|
1 |
COMBIN(14,1)*COMBIN(61,5) |
83,288,058 |
0 |
0 |
|
0 |
COMBIN(14,0)*COMBIN(61,6) |
55,525,372 |
0 |
0 |
|
Total |
201,359,550 |
171,858,050 |
Expected return = ______ 85.35%_________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
7 |
COMBIN(10,7)*COMBIN(30,0) |
120 |
2500 |
300,000 |
|
6 |
COMBIN(10,6)*COMBIN(30,1) |
6,300 |
250 |
1,575,000 |
|
5 |
COMBIN(10,5)*COMBIN(30,2) |
109,620 |
50 |
5,481,000 |
|
4 |
COMBIN(10,4)*COMBIN(30,3) |
852,600 |
5 |
4,263,000 |
|
3 |
COMBIN(10,3)*COMBIN(30,4) |
3,288,600 |
1 |
3,288,600 |
|
2 |
COMBIN(10,2)*COMBIN(30,5) |
6,412,770 |
0 |
0 |
|
1 |
COMBIN(10,1)*COMBIN(30,6) |
5,937,750 |
0 |
0 |
|
0 |
COMBIN(10,0)*COMBIN(30,7) |
2,035,800 |
1 |
2,035,800 |
|
Total |
18,643,560 |
16,943,400 |
Expected return = _______ 90.88%________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
8 |
COMBIN(12,8)*COMBIN(38,0) |
495 |
5000 |
2,475,000 |
|
7 |
COMBIN(12,7)*COMBIN(38,1) |
30,096 |
1000 |
30,096,000 |
|
6 |
COMBIN(12,6)*COMBIN(38,2) |
649,572 |
50 |
32,478,600 |
|
5 |
COMBIN(12,5)*COMBIN(38,3) |
6,681,312 |
15 |
100,219,680 |
|
4 |
COMBIN(12,4)*COMBIN(38,4) |
36,538,425 |
5 |
182,692,125 |
|
3 |
COMBIN(12,3)*COMBIN(38,5) |
110,427,240 |
1 |
110,427,240 |
|
2 |
COMBIN(12,2)*COMBIN(38,6) |
182,204,946 |
0 |
0 |
|
1 |
COMBIN(12,1)*COMBIN(38,7) |
151,443,072 |
0 |
0 |
|
0 |
COMBIN(12,0)*COMBIN(38,8) |
48,903,492 |
0 |
0 |
|
Total |
536,878,650 |
458,388,645 |
Expected return = ___ 85.38%____________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
9 |
COMBIN(15,9)*COMBIN(45,0) |
5,005 |
10000 |
50,050,000 |
|
8 |
COMBIN(15,8)*COMBIN(45,1) |
289,575 |
2000 |
579,150,000 |
|
7 |
COMBIN(15,7)*COMBIN(45,2) |
6,370,650 |
100 |
637,065,000 |
|
6 |
COMBIN(15,6)*COMBIN(45,3) |
71,020,950 |
20 |
1,420,419,000 |
|
5 |
COMBIN(15,5)*COMBIN(45,4) |
447,431,985 |
10 |
4,474,319,850 |
|
4 |
COMBIN(15,4)*COMBIN(45,5) |
1,667,701,035 |
2 |
3,335,402,070 |
|
3 |
COMBIN(15,3)*COMBIN(45,6) |
3,706,002,300 |
1 |
3,706,002,300 |
|
2 |
COMBIN(15,2)*COMBIN(45,7) |
4,764,860,100 |
0 |
0 |
|
1 |
COMBIN(15,1)*COMBIN(45,8) |
3,233,297,925 |
0 |
0 |
|
0 |
COMBIN(15,0)*COMBIN(45,9) |
886,163,135 |
0 |
0 |
|
Total |
14,783,142,660 |
14,202,408,220 |
Expected return = _____ 96.07%__________
|
Catch |
Formula |
Combinations |
Pays |
Return |
|
10 |
COMBIN(12,10)*COMBIN(60,0) |
66 |
1000000 |
66,000,000 |
|
9 |
COMBIN(12,9)*COMBIN(60,1) |
13,200 |
100000 |
1,320,000,000 |
|
8 |
COMBIN(12,8)*COMBIN(60,2) |
876,150 |
10000 |
8,761,500,000 |
|
7 |
COMBIN(12,7)*COMBIN(60,3) |
27,102,240 |
1000 |
27,102,240,000 |
|
6 |
COMBIN(12,6)*COMBIN(60,4) |
450,574,740 |
100 |
45,057,474,000 |
|
5 |
COMBIN(12,5)*COMBIN(60,5) |
4,325,517,504 |
10 |
43,255,175,040 |
|
4 |
COMBIN(12,4)*COMBIN(60,6) |
24,781,610,700 |
5 |
123,908,053,500 |
|
3 |
COMBIN(12,3)*COMBIN(60,7) |
84,965,522,400 |
2 |
169,931,044,800 |
|
2 |
COMBIN(12,2)*COMBIN(60,8) |
168,868,975,770 |
0 |
0 |
|
1 |
COMBIN(12,1)*COMBIN(60,9) |
177,397,711,920 |
0 |
0 |
|
0 |
COMBIN(12,0)*COMBIN(60,12) |
75,394,027,566 |
1 |
75,394,027,566 |
|
Total |
536,211,932,256 |
494,795,514,906 |
Expected return = ______ 92.28%_________