Answer Happy

Introduction You are a partner in a small charter air services company. You and your partners want to reduce maintenance costs and have decided to standardize flight instrumentation across the fleet of 11 different aircraft types. You need to evaluate the altimeters in each aircraft. The first step in the process is to collect and analyze data from the different altimeters installed in the aircraft. There is an altimeter reading on flight number one that looks unusual, and you want to compare that against the other 19 flights in the sample. The assignment's goal is to effectively use the formulas and functions of Excel to evaluate your data, then interpret the results. Complete the following. • Calculate the data and find the z score. • Run a histogram on the data. • Interpret the data. • Post your results. • Discuss with your colleagues. • Calculate the Data To calculate the data and find the z score, open the STAT 211 Altimeter Readings (XLSX) spreadsheet. In cell A1, enter a two-digit number. The first number can be 4, followed by the first digit of your social security number, driver's license number, government identification number, etc. The number in A1 represents the error for the altimeter made by the ACME Altimeter Company - the altimeter that you are worried about. In cells A2-A20, copy 19 more random numbers. Use columns G-P on the spreadsheet to obtain the 19 numbers. These numbers represent the sample of altimeter readings from 19 other flights of different aircraft with different altimeters. Use the spreadsheet data to: • Find the mean for the sample. • Find the standard deviation for the sample. . Find the z score for the ACME Altimeter. Follow the instructions in the video and/or the written step-by-step instructions. • Excel: Mean, Sdev-s, and Z Score (Studio 9:43)
Run a Histogram Now that you have calculated the data, including the z score, run a histogram of the data in Column A. To learn how to make a histogram, review this video. How to Make a Histogram in Excel 2016 (YouTube 7:48) When you are finished, your spreadsheet should look similar to this one. Remember, the numbers and distribution shape will depend on the numbers you used. You may have a more "normal" looking distribution, for example. Example of Histogram of Altimeter Error Sample 42 Flt #1 Z score 2.11 -27 19 Mean 8.8 Standard Deviation 15.73 Chart Title 6o O OVANOO OÜ 6 6 8 6 4 2 0 (-17, -7] [-27, -17] (3, 13] (23,33] (-7,3] (13,23] (33,43] 19 18
File Home Insert Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful—files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X E15 X fic A B с D E R R S T F F Flight G H 1 I KL M M Ν ο Ρ Q Q Altimeter Errors (copy any column of 19 values-put in column A2:A20) 1 1 Flt #1 Z score Altimeter Errors Paste any column from random number table at right -27 -27 -3 -1 -9 -38 7 -27 -29 - 13 2 2 2 3 Mean 3 14 14 9 20 48 -34 8 -27 -23 -13 7 7 32 4 4 -7 -8 -14 6 7 -50 -6 34 9 -27 Standard Deviatio -9 -9 7 N 2 19 -12 23 -41 -4 0 43 n 5 -4 -5 0 0 -4 -11 -25 -11 ON -25 -5 -37 -14 28 -45 -31 -47 7 8 8 21 -5 -24 7 17 -1 0 -37 -15 4 25 3 11 42 31 23 0 0 0 4 1 4 38 13 15 -37 3 -5 8 -19 10 0 2 3 -1 34 4 -43 43 -23 -41 11 5 4 2 14 8 5 8 8 -22 49 34 12 6 7 7 -1 2 -2 -18 1 -47 -42 37 8 16 33 4 13 14 15 816666 WRE6600 V 6 9 3 -4 43 10 22 -32 -40 32 1 44 9 12 48 49 5 5 15 16 17 19 -6 -16 6 -9 46 15 41 -12 -10 3 19 18 -4 28 40 -41 -34 -29 -39 17 10 9 8 4 3 40 32 28 -18 -30 22 21 -13 0 46 -23 -3 23 25 19 -36 -29 27 -3 -27 -15 29 -31 -27 - 1 25 -42 -23 35 -20 8 20 29 30 8 13 -35 -6 2 -22 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A big thanks to Dr. John Barstow (WW Adjunct Instructor) for his contributions to this 22 assignment! 23 24 25 26 27 28 29 30 31 32 Tip is below! 95% 95% of values are within 2 2 standard deviations of the mean +2 +3