Order Now

Airshow Day 1: Mean and Standard Deviation

Airshow Day 1: Mean and Standard Deviation

This discussion provides a simulated exercise using two of the most popular descriptive statistics, mean and standard deviation. You are strongly encouraged to complete the textbook reading and start the MyStatLab Homework assignment before beginning this discussion. You need to be familiar with mean and standard deviation, their interpretation and why they are typically calculated and reported together.

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 incident.

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.

Save your work as a file to your computer and then read the Canvas instructions on How do I embed an image in a discussion reply as a student? (Links to an external site.)

Post & Discuss
Post the image of your spreadsheet into the discussion area along with a narrative of your findings before the fourth day of the module week to receive full credit. Address the following questions in your narrative.

Is there a difference between the type of aircraft (i.e., Tankers, Transports, Bombers, and Fighters)?
What do the differences (if any) appear to indicate?
Return at least once later in the module week to provide meaningful comments to two or more of your classmates’ posts. DO NOT “post and run” – making all three posts in the same visit. You need multiple visits to the discussion area to gain multiple perspectives by reading all of the posts and replies.

Review the Discussion Rubric for detailed grading information.



Airshow Day 1: Mean and Standard Deviation




Order Now

Calculate Your Order Price

Price (USD)