During Day 2 of the airshow, you are required to select and report an Airshow Champion. Use the spreadsheet that you created for the Module 3 - Discussion: Airshow Day 2: Probability discussion to: 1. Determine the aircraft winner. 2. Report the probability of another aircraft scoring higher than the winner. Report values of probability to four decimal places, i.e., p = 0.1234. AIRSHOW - US MILITARY AIRCRAFT PERFORMANCE Transport Bomber C-17 B-52 Fighters Sortie Sortie F-15 F-16 F-22 F-35 Mean, Standard Deviation, 3.70 3.65 3.82 3.24 2.50 4.26 1.80 2.12 2.65 2.00 3.00 2.65 Tankers KC-135 KC-10 2.36 2.30 2.15 2.36 2.45 2.55 3.00 1.75 3.00 1.75 3.00 2.75 2.95 3.10 2.70 1.60 14.71 3.00 3.00 3.81 2.00 4.00 2.65 4.00 2.50 3.00 Flight Name Sortie 1 Sortie 2 Sortie 3 Sortie 4 Sortie 5 Sortie 6 Sortie 7 Sortie 8 Sortie 9 Sortie 10 Sortie 11 Sortie 12 Sortie 13 Sortie 14 Sortie 15 Sortie 16 Sortie 17 1.25 1.00 1.10 1.05 1.10 0.45 0.50 1.26 0.98 0.98 0.12 0.96 0.75 0.65 0.13 0.12 0.97 0.92 5.60 1.00 1.00 1.15 1.00 1.00 1.15 1.00 1.40 1.25 1.40 3.24 1.98 2.50 1.96 3.70 1.05 10.50 1.97 1.92 Mean, Standard Deviation, Z-Score Value Probability During Day 2 of the airshow, you are required to select and report an Airshow Champion. Use the spreadsheet that you created for the Module 3 - Discussion: Airshow Day 2: Probability discussion to: 1. Determine the aircraft winner. 2. Report the probability of another aircraft scoring higher than the winner. Report values of probability to four decimal places, i.e., p = 0.1234. AIRSHOW - US MILITARY AIRCRAFT PERFORMANCE Transport Bomber C-17 B-52 Fighters Sortie Sortie F-15 F-16 F-22 F-35 Mean, Standard Deviation, 3.70 3.65 3.82 3.24 2.50 4.26 1.80 2.12 2.65 2.00 3.00 2.65 Tankers KC-135 KC-10 2.36 2.30 2.15 2.36 2.45 2.55 3.00 1.75 3.00 1.75 3.00 2.75 2.95 3.10 2.70 1.60 14.71 3.00 3.00 3.81 2.00 4.00 2.65 4.00 2.50 3.00 Flight Name Sortie 1 Sortie 2 Sortie 3 Sortie 4 Sortie 5 Sortie 6 Sortie 7 Sortie 8 Sortie 9 Sortie 10 Sortie 11 Sortie 12 Sortie 13 Sortie 14 Sortie 15 Sortie 16 Sortie 17 1.25 1.00 1.10 1.05 1.10 0.45 0.50 1.26 0.98 0.98 0.12 0.96 0.75 0.65 0.13 0.12 0.97 0.92 5.60 1.00 1.00 1.15 1.00 1.00 1.15 1.00 1.40 1.25 1.40 3.24 1.98 2.50 1.96 3.70 1.05 10.50 1.97 1.92 Mean, Standard Deviation, Z-Score Value Probability