Question: PLEASE RE DO PART A USING P$-$CHART

Please note that this problem has three parts $($a$,$ b$,$ and c$).$

You may need to scroll the screen down and navigate left and right to see the whole problem.

Clearly label your parts when answering.

You are allowed a Maximum of $3$ Files for this problem.

Show all calculations$/$results to at least FOUR PLACES AFTER THE DECIMAL POINT $($except

when all succeeding digits are zeros$).$

Must show work completely $($including all calculations$/$steps$).$ Failure to do so will result in

a score of $"0,"$ even if your final answer is correct.

Fly Can is a domestic airline, operated within the country. One of Fly Can's competitive priorities is

on$-$time arrivals. The Quality VP decided to personally monitor Fly Can's performance. Each week for

the past $30$ weeks, Quality VP checked a random sample of $275$ flight arrivals for on$-$time

performance. The table below contains the number of late flights that did not meet Fly Can's definition

of $"$on time" arrivals. The results of the $30$ samples are shown in the table.

Hints:

Total number of Late flights is $231.$

No chart drawing required for this problem.

$($a$)$ With this kind of data, which type of process control chart is the most appropriate? Based on

the above information, for $90\%$ confidence level. Calculate the relevant center line$($s$)$ and

upper and lower control limits$.$

$($b$)$ Samples for the next five weeks are reported in the table below. On base of limits calculated in

part $($a$),$ is the process in control or not, justify?

$($c$)$ This is independent of parts $($a$),$ and $($b$).$

In an effort to statistically control the flight system, eleven flights randomly picked from the

Paragon airport every hour. The data showing how many minutes late from their scheduled

time are recorded sequentially for the samples over the $14$ hours of operation. The overall

average of the $14$ sample means is $12\mathrm{.}8639$ minutes. The overall average of the $14$ sample

ranges is $17\mathrm{.}9358$ minutes. Considering that three sigma control limits are applied in the

statistical process control of this study, determine the upper and lower control limits of the

X$-$bar chart and R$-$chart. Please help with thhis show all your work, and do not just use an excel program to input the data, show ALL your wokr step by step.