project probability in excel

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?

 
Looking for solution of this Assignment?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay