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.

Instruction Files

Related Questions in statistics category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.