Examine, Construct, & Address Typically when researching a business or academic issue, you would ask a question about something and form a hypothesis. You would then collect the data and test it to see if the null hypothesis [no diffe rence} is supported or refuted. Then you would present the findings. For the purposes of this exam, we are revising some of these steps to focus on the statistical testing and interpretation aspect of hypothesis testing. The nal exam in this course is a "practical exam" that spans Modules 3 and 9. In this Part | assignment, you will reyiew a data set and construct a hypothesis statement. In the Module 9. Part I! assignment. you will run the appropriate tests and interpret the results. The Final Practical Exam is worth 15% of your nal grade. Before you get started, reyiew the Module it HeadsUp: Final Practical Exam page for additional details. Now, open and carefully examine the data on the STAT 211 Altimeter Error spreadsheet {XLSXL is Also, review the Exam Related Resources section of the Module 3 Readings 5: Resources page to see demonstrations on how to run statistical tests in Excel. Please answer the four questions under Part | [A through D] located in the spreadsheet to the right of the data table. Compare two different companies or compare one company vs ACME error before and Hypothesized mean Brand X error before and after after maintenance maintenance ACME ACME Brand X Brand X Altimeter Altimeter Altimeter error | Altimeter error Altimeter error before error after Altimeter Altimeter before Altimeter after Altimeter Altimeter Brand A adjustment- Brand B Brand C adjustment- Brand D adjustment- Brand E adjustment- Brand F 126 calibration calibration 20 148 calibration 41 calibration 26 0 117 123 14 27 96 5 42 18 40 12 21 33 32 24 92 45 15 9 36 18 12 96 78 12 33 99 66 12 90 114 75 40 12 84 30 99 27 27 36 126 26 75 75 27 33 66 78 96 18 9 135 3 30 75 96 15 4 99 96 124 17 12 15 87 30 57 30 2 27 120 132 22 30 96 17 21 12 21 65 51 15 12 33 102 87 23 27 6 111 39 69 9 26 69 93 26 16 33 81 34 102 117 39 108 65 18 45 18 75 144 126 3 18 130 93 24 9 59 108 135 29 87 129 30 20 16 57 18 30 62 36 42 33 50 147 33 54 15 43 36 14 78 27 130 12 33 60 69 21 27 147 6 60 87 78 44 15 96 129 75 126 129 15 138 96 41 9 51 9 138 129 9 9 69 57 53 6 87 57 15 3 0 15 151 78 30 36 18 141 30 36 * Note - Error (distance from zero) achieved by converting data to absolute values. 96 15 75.35 29.15 99.25 34.35 50.15 75.15 75.9 20.7 67.5 12 8FINAL PRACTICAL EXAM PART I (Fill in the light blue sections for A though D) Part I Questions (due at end of module 8 - requires no calculation until module 9 turn in of Part II) Describe what you are comparing. A) State your hypothesis in a sentence, This can be as simple as: "The altimeter error for Brand _ is higher than Brand _." B) (Your hypothesis does not have to be in statistical notation for Part I of the final). Indicate the appropriate t-test that you will use to evaluate your hypothesis. C) State the alpha level. D) 0=FINAL PRACTICAL EXAM PART II (Fill in the light green sections for E though D Part II Questions (due at the end of Module 9) State the hypothesis in a sentence (for example): "The altimeter error for Brand _ is higher than Brand _." Express that idea using scientific notation. (See examples in your text if you are unsure) FI Null Hypothesis - HO: Alternate Hypothesis - HA: State the appropriate t-test used to evaluate the hypothesis and show results table G Alpha (o) level P-value P = State in a sentence or two whether the hypothesis is rejected or if there is not enough evidence to reject the null hypotheses and what the results mean.In Modules 8 and 9, you will take a two-part final practical exam. In Part I, you will examine a set of sample data, formulate a hypothesis, determine the appropriate ttest to run. and determine the alpha to} level. In Part II. after input on Part I from your instructor. you will run the test and interpret the results. Take some time now to think about the exam. In Part L you will evaluate an aircraft altimeter data sample from different companies to determine if there are any differences in error. You have the following three options for running the appropriate ttest. I Option 1 compare one brand against a hypothesized mean to determine if the brand is statistically different than the assumed norm. In this case, you would have to cite where the hypothesized population mean came from. I Option 2 compare one brand against another to see if there are signicant differences between them. I Option 3 - compare either altimeter error of ACME or Brand X before adjustment and calibration and after adjustment and calibration to see if there are any differences in the means {performance}. Based on the type of dependent variable data {ratio} and the type of question in the scenario, you will use a t test. As you know, there are three different types of ttests you can use: I Dne sample ttest [test for one population mean using Excel} I Two sample ttest {hypothesis test for two population means using Excel} I Paired ttest [compare before and after yalues for one type using Excel} Reyiew the Module 8 - Final Practical Exam: Part | assignment now. It is due lay the end of module week El, but you can turn it in early and get feedback from your instructor