Question

Over the past six months, 70 flights on one route arrived early, 150 arrived on time, 15 were late, and 25 were canceled.

A) What is the probability that a flight is early? On time? Late?Canceled?

B) Are these outcomes mutually exclusive?

C) What is the probability that a flight is either early or on time?

Will you please show work in excel. Thank you

Answer 1

The data that has been input in MS Excel is given below.


(A) Prob.(flight is early) = 70/260 = 0.2692 (Excel command -> =B1/E1)
Prob.(flight is on time) = 150/260 = 0.5769 (Excel command -> =B2/E1)
Prob.(flight is late) = 15/260 = 0.0577 (Excel command -> =B3/E1)
Prob.(flight is cancelled) = 25/260 = 0.0962 (Excel command -> =B4/E1)

(B) These outcomes are mutually exclusive because they don't happen at the same time, that is, one flight cannot arrive early and arrive late at the same time.

(C) Prob.(flight is either early or on time) = (70+150)/260 =0.8462 (Excel command -> =(B1+B2)/E1)