PSY:5110 Applied statistics Week 3 - Assignment: Calculate and Interpret Data

Complete the following steps to add the option for data analysis to Excel 2016.

1. Open Excel 2016.

2. Click “File.”

3. Click “Options.”

4. Select “Add-ins” from the list of Options that appear on the left side of your screen.

5. In the “Manage” area, click “Go.”

6. The following screen will appear. Then, make sure that Analysis ToolPak and Analysis ToolPak - VBA are checked.

7. Click OK.

The “Data Analysis” area will now appear in the “Data” tab. This is the last option in this row and to the right of “Outline”:

8. Click on “Data Analysis” to view the options for inferential statistical tests, as well as options for descriptive statistics:

9. Select the “Descriptive Statistics” option; then, complete the following field:

The “Input Range” consists of the cells you want included in the analysis. To obtain the means for each age group and drug condition, be sure to select each set of BDI scores separately (i.e., younger adults in the placebo group, older adults in the placebo group, younger adults in the Drug A group, older adults in the Drug A group).

10. Click OK.