v 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 ight instrumentation across the eet of 11 different aircraft types. You need to evaluate the altimeters in each aircraft. The rst step in the process is to collect and analyze data from the different altimeters installed in the aircraft. There is an altimeter reading on ight number one that looks unusual, and you want to compare that against the other 19 ights 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 colle agues. v Calculate the Data To calculate the data and nd the z score. open the STAT 211 Altimeter Readings (XLSX) spreadsheet. i, In cell A1, entera twodigit number. The rst number can be 4. followed bythe rst digit of your social security number, driver's license number. government identication 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 AZAZU, copy 19 more random numbers. Use columns GP on the spreadsheet to obtain the 19 numbers. These numbers represent the sample of altimeter readings from 19 other ights of different aircraft with different altimeters. Use the spreadsheet data to: - Find the mean for the sample. - Find the standard deviabon for the sample. - Find the z score for the ACM E Altimeter. Follow the instructions in the video and!or the written stepbystep instructions. - Excel: Mean. Sdevs, and Z Score [Studio 9:43} EMBRY-RIDDLE J's: AC _1i__]\\_ltll::q_ll L__lr'1i\\ D Excel: Mean. Sdeys, and 2 Score Transcript {DOCK} i, - StepbyStep Instructions: Mean, Standard Deviation. and 2 Score I Note: Your numbers will look different than your classmates due to the random numbers used. v 'un a 'Istogram 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 ?:43]_L7' When you are nished, 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 2 score -27 19 Mean -8 Standard Deviation 15.73 Chart Title (-115 -?] (3, 13] {23, 33] [-3, -1?] (-Ir', 3] {13, 23] {33, 43] I LD I U1 8 O O 2 4 7 8 9 |' LD |' m v Interpret, Post, & Discuss The nal steps in the process are to interpret the results, post your spreadsheet and data interpretation, and then discuss the information with your colleagues. Answer the following questions: - What is the mean of your sample? - What is the standard deviation of your sample? - What is the z score, and is it unusual? Why orwhy not? - What is the "shape" of the distribution? Is it skewed to the right or left? - Do we have enough evidence to support the idea that the ACME Altimeter has an unusually large error issue? * Tip: Copy and paste the questions into your initial post. Make your initial post by the end of the fourth clay of the module week. Remember to attach your spreadsheet. Return to the discussion later in the module week to read the posts of your classmates and respond to the posts of at least two other students. In your replies, discuss how your results differed from your classmates' and why. Review the Discussion Rubric for detailed grading instructions. This activity supports Module Objectives 1, 2, 5, and 10 and Learning Outcomes 2, 5, o, and 8