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%__________

 

  1. Consider a keno game in which there are 100 balls, the player picks 5 and the casino draws 25. Fill in the following table to determine the expected return.
  2. 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%__________

     

     

  3. Consider a keno game in which there are 75 balls, the player picks 6 and the casino draws 14. Fill in the following table to determine the expected return.
  4. 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%_________

     

  5. Consider a keno game in which there are 40 balls, the player picks 7 and the casino draws 10. Fill in the following table to determine the expected return.
  6. 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%________

  7. Consider a keno game in which there are 50 balls, the player picks 8 and the casino draws 12. Fill in the following table to determine the expected return.
  8. 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%____________

     

  9. Consider a keno game in which there are 60 balls, the player picks 9 and the casino draws 15. Fill in the following table to determine the expected return.
  10. 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%__________

  11. Consider a keno game in which there are 72 balls, the player picks 10 and the casino draws 12. Fill in the following table to determine the expected return.

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%_________