Question

Calibri (Body) e2 wrap Text General Paste y Format Blyv 田vgvAv $v% , 儲鼎 Conditional Format Cell Formatting as Table Styles Merge & Center v Insert Delete F s M22 Fighthers F-22 Tankers Transport Bomber C-17 Air Show Fight Name KC135KC-10 B-52 F-15 F-16 F-35 Standard deviation Day Number 2.36 3.65 3.82 2.5 0.75 0.13 0.97 Standard Deviation 2.97 0.52 0.08 0 1 111 000001061010 3. 2 2 2 2 2 2 1 1 1 10 1 1 1 3 2 3 92 .6-11 000 11 2.5 96 86 23 LES 1.1 0.5 111 105 in azi 1.8 2 65 111 25 1.4 2 2 2.5 2.5 3- 33 .8 4 4 2

Day 2 of the airshow arrives, and the weather is worsening. The temperature is 50^oF, and strong thunderstorms are predicted. Continuing intermittent moderate to strong runway crosswinds (25 Knots sustained, with gusts to 40 Knots). Fortunately, all Day 2 flying sorties are accomplished with only minor incidents.

Your team collected these simulated data for Day 2 flying sorties:

POST A NARRATIVE AND AN EXPLANATION FROM THE FINDINGS IN THE GRAPH

Answer 1

Answer:

transport bomber fighters deviatiorn B-52 Flight name Sortie 1 Sortie 2 Sortie 3 Sortie 4 Sortie 5 Sortie 6 Sortie 7 KC-135 KC-10 C-17 F-15 F-16 F-22 F-35 3.70 3.24 3.65 3.82 13.53 2.50 4.26 14.45 32.05 32.62 1.25 1.26 0.98 Sortie 9 3.49 count(n) 1.16 Standard 0.62221.0003 0.1297 1.4060 1.3242 1.7282 Using Excel formula Average function for Mean STDEV P function for standard deviation