Examine, Construct, & Address

A man sitting in front of a laptop reading a paper document with a calculator and cup of coffee.

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 difference$)$ 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 final exam in this course is a "practical exam" that spans Modules $8$ and $9.$ In this Part I assignment, you will review a data set and construct a hypothesis statement. In the Module $9,$ Part II assignment, you will run the appropriate tests and interpret the results. The Final Practical Exam is worth $15\%$ of your final grade.

In Part I, you will examine a set of sample data, formulate a hypothesis, determine the appropriate t$-$test to run, and determine the alpha $()$ level.

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 t$-$test.

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.

Option $2-$ compare one brand against another to see if there are significant differences between them.

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 t$-$tests you can use:

One sample t$-$test $($test for one population mean using Excel$)$

Two sample t$-$test $($hypothesis test for two population means using Excel$)$

Paired t$-$test $($compare before and after values for one type using Excel$)$

Now, open and carefully examine the data on the STAT $211$ Altimeter Error spreadsheet $($XLSX$).$ Download STAT $211$ Altimeter Error spreadsheet $($XLSX$).$Also, review the Exam Related Resources section of the Module $8-$ Readings & Resources page to see demonstrations on how to run statistical tests in Excel.

Please answer the four questions under Part I $($A through D$)$ located in the spreadsheet of the data table.

Final practical exam part $1,$ light blue sections A through D$.$

Submit

Once you have answered the four questions in the spreadsheet under Part I, submit the spreadsheet early in the module week. Your instructor will provide feedback on Part I no later than the third day of Module $9.$

Save your assignment using a naming convention that includes your first and last name and the activity number $($or description$).$ Do not add punctuation or special characters.

Review the Assignment Rubric for detailed grading instructions.

This activity supports Module Objectives $1$ and $2$ and Learning