Question

Frequency Distribution for Number of Success Number of Success (xi) C3 іх C3 25 18 36 4. Probability 0.172413793 0.431034483 0.155172414 0.206896552 0.017241379 0.017241379 Frequency (fi) 10 25 2 12 4 1 Sum 58 1.5172 Mean =

The success average of a hockey player is the number of “points scored” divided by the number of “shots on goal.” Recently, a certain professional league player’s shots on goal and corresponding points scored were recorded for 400 consecutive games. The consecutive games span more than one season. Since each game is different, the number of shots and points scored both vary. For this particular player, there were from 0 to 15 shots. Thus, one can sort the more than 400 games into 16 categories:

0 shots
1 shot
2 shots
.
.
.
14 shots
15 shots

Consider the games where the player had exactly five shots on goal. A similar analysis can be done for each of the other shots category. Download the file titled Hockey. It contains a scatter plot of the Five Shots number of successes versus frequency. To compare the results to the Binomial Distribution, complete the following:

​​​​​​​

1. Using the frequency distribution, what is the player’s success average for five shots? In part 3, note that the numerator in the formula for the mean is the total number of successes. The total number of shots is the denominator of the formula for the mean multiplied by. The Binomial Distribution is uniquely determined by n, the number of trials, and p, the probability of “success” on each trial. Using Excel, construct the Binomial Probability Distribution for five trials, n, and probability of success, p, as the success average in part 5. Here is an explanation of the BINOM.DIST function (Links to an external site.)Links to an external site. in Excel
2. For example, In Excel
   =BINOM.DIST(7,15,0.7,FALSE)

Answer 1

tne The numben a successfut shots made by S shots that he-atter pledoan 一player-0 un--o ㄧ-the listrbuted becowe here be considerad to be bionamilly is n 5 ee ou Pixing the numben of trials The pro babi lity that the playen success lully makes any one f these Shots ús indspanden of the loability that the playert makes Qnly oth ploynit can be en of these 5 shots. assummed that the pro babili Success ull kin S ho ins the s eanyattemp ted Shot on theb bionomial distribution s sans-ed and we can. Consider tha·successful shts out Rve attenpted shots to be bionomia buted mean humben esuccess.es would be gvon bo p Totol shots successfully mada /Totc shots atfempted Thu-- above will give the player successfully matas onq shot tha S shoj o thpr bo bility of sucess un a given Shof babil t would be a Drobabili 2 stibution b o i Lol Success Julm C)s euhvel