Use MS Excel to do the following:
1. Three men were trying to make the football team as punters. The coach had each of them punt the ball 50 times and the distances were recorded (see Excel Spreadsheet
Punters file on Moodle).
a) Compute the variance and standard deviation for each punter.
b) What do these statistics tell you about each punter?

Binomial
2. In a Bon Appetit poll, 38% of people said that chocolate was their favorite flavor of ice cream. A sample of 20 people was asked to name their favorite flavor of
ice cream. What is the probability that half or more of them prefer chocolate?
Poisson
3. A report to the Toronto city council stated that there are on average 30 water line breaks per 100km per year in the city of Toronto. Outside of Toronto, the
average number of breaks is 15 per 100km per year.
a) Find the probability that in a stretch of 100km in Toronto there are 35 or more breaks next year.
b) Find the probability that there are 12 or fewer breaks in a stretch of 100km outside of Toronto next year.

This is a group assignment and should be done together as a team. Enter all the group members’ names and student ID. Only one submission should be made for the group.
Due date: Assignment is due before the class on March 21.