Statistics Assignments Using Excel® Assignment #7: Single Sample Tests (Solved)
statistics
Description
Statistics Assignments Using Excel® Assignment #7: Single Sample Tests
Part 1
The data below are from a study investigating the factors influencing performance on standardized math exams. It is known that the population mean on the exam is 77.45 (σ = 7.95). The group scores below are from a randomly collected sample of people who have had 2 years or more of foreign language coursework. Does this group differ significantly from the population? Use α = .05. 1. Using Excel, perform the appropriate statistical test. 2. Label the worksheet for Part I “math test data”. 3. Using words, report the statistical results and your research conclusion in a text box. Part 2 The data below are from a laboratory study investigating the effectiveness of a drug designed to reduce alcohol cravings in a sample of mice that are genetically bred with a predisposition toward alcohol addiction. For the population of this type of mouse, it is known that its mean alcohol consumption is 600ml per day when alcohol is freely available. The data below are the daily consumption amounts for mice injected with Naltrexone, a drug designed to reduce alcohol cravings. Does the drug significantly reduce alcohol consumption? Use α = .05. 1. Using Excel, perform the appropriate statistical test. 2. Label the worksheet for
Part 2 “mouse alcohol data”. 3. Using words, report the statistical results and your research conclusion in a text box.
