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.
To get started, carefully examine the data on the STAT 222 Car Details 2019 Models spreadsheet (XLSX). Download STAT 222 Car Details 2019 Models 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.
Then, construct a hypothesis and address the following in a document.
Describe what you are comparing.
State your hypothesis in a sentence.
Indicate the appropriate t or z test that you will use to evaluate your hypothesis.
State the alpha (α) level
Suggestion from the Instructor.
The EPA has reported that the average MPG of all USA cars in 2019. was 24.9.
Your data have 2019 Overall MPG (Column S) for all cars, USA and not USA. Construct a column for all USA cars MPG. There should be 52 data points by eliminating the four values for electric cars.
Select a sample of any size from the 52 values and test whether the mean MPG is equal to 24.9 (you can also test for greater than/less than 24.9).. Address the above required four items in constructing your hypothesis testing..
Submit your document to this assignment early in the module week. Your instructor will provide feedback on Part I no later than the third day of the next module week.
