Problem 2 - An airport wants to control the number of late departures.It randomly sampled 200 departing flights during each of the last 16 weeks and recorded whether the flight departed late or on-time.The table below shows the number of late departures for each weekly sample.Create a worksheet named "Problem 2" and paste the given data into it. Create a P Chart following steps a - i.A sample layout is provided at the end of this document.

Week

No. of Late Departures

1

2

2

3

3

4

4

3

5

3

6

4

7

3

8

3

9

2

10

4

11

2

12

4

13

3

14

1

15

2

16

3

a.In a textbook, briefly explain why a P chart should be used.

b.In a new column, calculate the sample statistic (proportion late) for each week.

c.Enter sample size (n) and number of samples in clearly labeled cells.

d.Compute the mean ( ) and put in a clearly labeled cell.

e.Compute the standard deviation _p and put in a clearly labeled cell.

f.Compute the lower (LCL) and upper (UCL) control limits.Use a 95.45% confidence level.Put control limits and Z values in clearly labeled cells. Note, you can automatically change a negative LCL to 0 by placing the expression used to compute the LCL inside a max function which returns the maximum of the computed result and 0 e.g. =MAX(LCL expression, 0).

g.Create a scatter chart showing samples proportions by week and control limits. Create a new column with the LCL and UCL value for each of the 16 weeks (e.g. values will be repeated since limits are a constant). Select the week, sample proportions, LCL and UCL column sand choose insert scatter chart.

h.In a textbook, explain whether or not flight departure times are in control.

i.During week 17, 5 of a sample of 200 flights departed late.In a text box, explain whether this should be investigated and why. Use specific values to justify your answer. (Note - you should not recompute the control limits to answer this question).