STAT3309 Discrete Probability Distributions Excel Project 2

STAT 3309 Project 2 – Discrete Probability Distributions Space Shuttle Challenger Instructions: Use Excel to complete the following questions. Attach copies of the Excel pages or embed the Excel work in your write-up. The January 1986 mission of the Space Shuttle Challenger was the 25th such shuttle mission. It was unsuccessful due to an explosion caused by an O-ring seal failure. 1. According the NASA, the probability of such a failure in a single mission was 1/60,000. Using this value of p and assuming all missions are independent, calculate the probability of no mission failures in 25 attempts. Then calculate the probability of at least one mission failure in 25 attempts. 2. According to a study conducted for the Air Force, the probability of such a failure in a single mission was 1/35. Recalculate the probability of no mission failures in 25 attempts and the probability of at least one mission failure in 25 attempts. 3. Based on your answers in 1. and 2., which value of p seems more likely to be true? Explain. 4. How small must p be made in order to ensure that the probability of no mission failures in 25 attempts is .999?