What I really need is the Excel output and the Functions in Excel.

1. Trowbridge Manufacturing produces cases for personal computers and other electronic equipment. The quality control inspector for this company believes that a particular process is out of control. Normally, only 5% of all cases are deemed defective due to discolorations. If 6 such cases are sampled, what is the probability that there will be 0 defective cases if the process is operating correctly? What is the probability that there will be exactly 1 defective case?

2. Refer to the Trowbridge Manufacturing example in Problem 2-35. The quality control inspection procedure is to select 6 items, and if there are 0 or 1 defective cases in the group of 6, the process is said to be in control. If the number of defects is more than 1, the process is out of control. Suppose that the true proportion of defective items is 0.15. What is the probability that there will be 0 or 1 defect in a sample of 6 if the true proportion of defects is 0.15?

3. During normal business hours on the east coast, calls to the toll-free reservation number of the Nite Time Inn arrive at a rate of 5 per minute. It has been determined that the number of calls per minute can be described by the Poisson distribution. Find the probability that in the next minute, the number of calls arriving will be

(a) exactly 5

(b) exactly 4

(c) exactly 3

(d) exactly 6

(e) less than 2.