Mean and standard deviation

In this discussion, you are required to calculate and interpret reported mean and standard deviation values. In
the Module 2 – Assignment: Airshow Day 1: Winner, you will be required to concisely report results obtained in
this discussion.
Congratulations on your promotion! You are now leading the team. After one week in your new position, your
supervisor provides guidance for your new assignment, responsibility for an important and “very visible” task.
In one month, your airport is hosting an airshow that allows potential future customers to observe the flying
capabilities of civilian and military aircraft. Support teams are planning for over 100,000 to attend the two-day
event. Your tasks are to determine and officially report the “Winner;” a very prestigious honor; highly valued in
both civilian and military communities.
Fortunately, your predecessor (an Embry-Riddle graduate) has provided a Microsoft Excel template:
Day one arrives, the weather is almost perfect, clear skies, 70o F with intermittent moderate to strong runway
crosswinds (20 Knots sustained, gusts to 33 Knots). Fortunately, all flying sorties are accomplished without
Data were collected on each aircraft for each sortie. A value of zero (0) is the lowest possible score. Reported
data have units of standard deviations. Higher overall scores are better; smaller aircraft (column) standard
deviations are also better.
Data your team collected are reported in the Airshow – US Military Aircraft Performance chart.
In Microsoft Excel, complete the “Airshow – US Military Aircraft Performance” table by adding calculated
column and row values for mean and standard deviation; report your values to two decimal places (i.e., 0.12).
Remember, the focus of this discussion is understanding and interpreting two descriptive statistics, mean and
standard deviation.

Sample Solution