Question

1. Find the appropriate measure of center. Discuss why the chosen measure is most appropriate. Why did you decide against other possible measures of center?
2. Find the appropriate measure of variation. The measure of variation chosen here should match the measure of center chosen in Part 1.
3. Find the graph(s) needed to appropriately describe the data. These may be done by hand and inserted into the Word document.
4. Define a random variable (X) so that your chosen data set represents values of X.
5. Is your chosen random variable discrete or continuous? Explain how you know.
6. Would the Normal or Binomial distribution be a good fit for the underlying sample distribution of X? If one of them is a good fit, state how you would approximate the distribution parameters.
7. Calculate the probability that a flight will depart early or on-time.
8. Calculate the probability that a flight will arrive late.
9. Calculate the probability that a flight departs late or arrives early.
10. Assume now that the random variable X=Arrival Time is exactly normally distributed with mean m= -2.5 and standard deviation s= 23. Compute the probability of a flight arriving late based on this new information. Does this contradict your answer from Part 8?

All calculations must be performed in Excel. The Excel file must be submitted as part of the report.

I need help knowing what formulas to plug in when using excel, please help. I have no clue how to work out these questions in excel. I only got question 1 & 2 solved.

Answer 1

Solution: