Day 2 of the airshow arrives, and the weather is worsening. The temperature is 50oF, 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:

Module 3 Airshow Discussion Excel Template-1.xlsx

Complete

In Microsoft Excel, complete the “Airshow – US Military Aircraft Performance” table by calculating the column and row values for mean, standard deviation, and z-score column values and Probability columnvalues (use Sortie 10’s data mean as the value of “X” in the z-score equation); report your calculated values to two decimal places (i.e., 0.12). For reporting probability, use Table A-2 in your textbook and report the value of the Probability (upper-tail, i.e., greater than) to four decimal places (i.e., 0.1234).