ANSWER WITH EXCEL PLEASE

In this problem round all your probabilities to 4 decimals.

When a new machine is functioning properly, only 2% of the items produced are defective. Assume we randomly select two parts produced on the machine and that we are interested in the number of defective parts found.

A What is the probability at least 1 of the two parts is defective?

Airline passengers arrive randomly and independently at the passenger-screening facility at a major international airport. The mean arrival rate is 10 passengers per minute.

B What is the probability of at least two arrivals in the next minute?

The American Automobile Association reported that families planning to travel over the Memorial Day weekend would spend an average of $749. Assume the amount spent is normally distributed with a standard deviation of $225.

C What would the Memorial Day Weekend expenses have to be for the 5% of the families with the most expensive travel plans?