Reference no: EM132324508

Assignment -

Choose one of the attached data sets and analyze using the techniques discussed in class up to this point. This includes the following:

Find the appropriate measure of center. Discuss why the chosen measure is most appropriate. Why did you decide against other possible measures of center?

Find the appropriate measure of variation. The measure of variation chosen here should match the measure of center chosen in Part 1.

Find the graph(s) needed to appropriately describe the data. These may be done by hand and inserted into the Word document.

Define a random variable (X) so that your chosen data set represents values of X.

Is your chosen random variable discrete or continuous? Explain how you know.

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.

Calculate the probability that a flight will depart early or on-time.

Calculate the probability that a flight will arrive late.

Calculate the probability that a flight departs late or arrives early.

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?

Write a brief description (250-500 words) of the data set including the discussion required in the points above.

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