04 Mar In this assignment, you will be provided a
In this assignment, you will be provided a fictitious study.
- Click here for instructions on how to add the Data Analysis ToolPak to Microsoft Excel.ATTACHED
- Click here to download the study.ATTACHED
- Look at the variable values and read the descriptions of the variables. Which values appear to be unrealistic?
- Do these values have anything in common?
- Use Microsoft Excel to obtain the descriptive statistics.
- Save the Microsoft Excel workbook to a file and submit it with the final document. Eliminate the unrealistic values from the analysis by deleting the data for those values.
- Why do you think these values are unrealistic?
- Run the descriptive statistics again and then write a statement on what the eliminated values had in common. Would it be acceptable to eliminate these values from the study you would like to publish? Include the two results files and your comments about what the values had in common and prepare a report in a 1- to 2-page Microsoft Word document.
- Support your responses with examples.
- Cite any sources in APA format.
Install Analysis ToolPak
1. Open Excel, bring up a blank workbook, and click File. 2. On the left-hand side menu, all the way to the bottom, click Options 3. Click Add-ins 4. Click Analysis ToolPak 5. Click OK
,
Page 1 of 1 PSY2061 Research Methods Lab
© 2013 South University
Steroid Usage, Grip Strength, Aggression, and Happiness Study
Steroid Usage Grip Strength Aggression Happiness Investigator
3 12 7 5 1
11 49 19 7 1
23 54 30 3 1
15 19 21 6 1
19 64 24 7 2
4 20 5 10 2
19 57 19 5 2
13 21 18 11 2
24 78 36 14 3
6 15 32 11 3
14 17 4 9 3
29 87 26 5 4
2 12 8 5 4
17 74 22 6 4
4 35 6 7 4
Steroid Usage: The number entered reflects the number of weeks on steroids.
Grip Strength: The number registered on a hand meter. The larger the number, the stronger the person; the scale cannot go higher than 100.
Aggression: The number obtained on the McGuthry Aggression Inventory. The higher the number, the more aggression; the scale goes from 5 to 30.
Happiness: The number obtained on the Happiness Scale. The higher the number, the happier the person is; the scale goes from 0 to 15.
Investigator: The number assigned to the person who assessed the participant.
