Binomial Probabilities

Excel has a Built-In Binomial Function.

"=BINOM.DIST(k, n, p, Cumulative)"

If Cumulative is set to TRUE, then you get sum of probabilities from 0 to k

If Cumulative is set to False, then you get the exact P(k)

Use the "Binomial" Tab.The Vikings all-time winning percentage is 54.6%

Steps

1)In Cell B3 we need to use the following formula

=BINOM.DIST(A3,16,B$1,False)

2)Copy-paste into all of the entries in Column B

3)In Cell C3 we need to use the following formula

=BINOM.DIST(A3,16,B$1,True)

4)Copy Paste into the Rest of Column C

Questions

a)How do we know we have a probability distribution? (Hint: Try AutoSum)

b)What is the probability the Vikings win 9 games?9 or fewer?

c)What is the probability they win between 8 and 12 games? (Hint:Subtract C15-C10)

d)What is the Expected Win Total?What is an Expected Range of Wins?

(Remember E=np, S=,range:E-2S to E+2S)

e)Make a Line Graph of the PDF (Column B)

f)Make a Line Graph of the CDF (Column C)

Vikings datasheet

Vikes Win%: 0.546

Wins Probability Cumulative Probability

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16