Delivery Time	Percent customers looking for newspaper by time	Percent undelivered at time
6:00 AM	15%	38%
6:15 AM	5%	21%
6:30 AM	8%	22%
6:45 AM	6%	14%
7:00 AM	15%	7%
7:15 AM	12%	6%
7:30 AM	16%	4%
7:45 AM	3%	3%
8:00 AM	5%	3%
"Anytime"	15%	0%

The Herald marketing department is seeking to increasehome-delivery sales through an aggressive direct-marketing campaignthat includes mailings, discount coupons, and telephonesolicitations. Feedback from these efforts indicates that gettingtheir newspapers delivered early in the morning is a very importantfactor for both prospective and existing subscribers. After severalbrainstorming sessions, a team consisting of members from themarketing and circulation departments decided that guaranteeingnewspaper delivery by a specific time could be an important sellingpoint in retaining and getting new subscribers. The team concludedthat the Herald should offer a guarantee that customers willreceive their newspaper by a certain time or else that day’s issueis free. To assist the team in setting a guaranteed delivery time,Al Leslie, the research director, determined that the circulationdepartment had data that showed the percentage of newspapers yetundelivered every quarter hour from 6AM to 8AM. Jan Shapiroremembered that customers were asked on their subscription forms atwhat time they would be looking for their copy of the newspaper tobe delivered. These data were subsequently combined and areavailable below. Your job is to review the internal data andpropose a reasonable time (to the nearest quarter hour) toguarantee delivery. To help explore the effects of your choice,calculate the following probability: If a sample of 50 customers isselected on a given day, what is the probability, given yourselected delivery time, that a. Fewer than 3 customers will receivea free newspaper? b. 2, 3, or 4 customers will receive a freenewspaper? c. More than 5 customers will receive a few newspaper?Use the binomial distribution function in excel to perform requiredcalculations.