Introduction 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. Scenario 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: Template example for recording aircraft performance Text description of Microsoft Excel template (PDF)Preview the document 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. Data collected for aircraft performance Text description of Day 1 Data (PDF)Preview the document Complete 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.