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:

iven Answev thak of te attached data Seks and Eiven one analyed sing the tech nices dscussed in class uP to the excel unction point using to obtain mean the fov deep delay Mean Ave atage ((-4,-3,0, 18,-,3,, 6,-s, .o) -5.99 1Mean oon ARR -Delay Aveoage deloay (o,-,-5. 5,-1, 3, -S,8, 6,.. 14 devation stng Ercel function 2 Standayd deuiaution o deep - delay Standaid , 3.0,a8,-,3, u, 6,-5.) STDEVA deviation o ARR Delay Standayd Co.-3,-, -, 3, 3,.. .. ST Oev A 10. S3 to dvauo the bor plot fo Excel unction 3) using dep delay Scanned with CamScanner CS

Seavies Serics 2 Seacsy Seeniess 30 - 20 30 40 20 diap fau Son left side of the Hiom Gaph most negattvety SKwed most the tollows data So the distri bution the box Plot tov ustng Excel tunctton the dago Delay. ARR Seaies SEoies 2 Sestes 3 Saties Seou es S 30 10 20 60 -30 2o data falls on let ide et the From ayaph most ot t he folloas he negstie ly skeued dfstwibution ealy ata cs unbe v CamScanner On depa atu des

COuntte -4,- 3,0118, -3,, 6,-s, . .o (.°M 33 No mbean depantuaes ttme on C 3,0, a8,-1, 3,,-s --- Countie (.P9. 2 of depasture On data Numbea (-u,-3,018,- 1, 3,u,G,-5, .,o" COuntte de pasituotes TOto probabi lity no ot depatuaes on eaaly 33 4a probabilityhat no.of departuoles On tme 2 O-Ou3 pvoba bility no of depa8ttuaes that ate = O-25S depat eorle On time Probability thar fight Piaba- Paobabii ty bility ha ight depat caely t will depat test will 0.Ou3 O.10 O 0u 3 CS Scanned with CamScanner