The data set for this question set (Tab Q1 in the Excel data file) comes from a research project that tracks the elderly residents in a community to monitor their cognitive function and general health. Based on the literature, education is considered a protective factor against dementia, and memory decline is usually the first sign of dementia. So the researchers would like to know whether education level (measured in number of years of formal schooling) is correlated with memory function (a standardized memory test score) in their sample of elderly residents. a. Create a scatter plot between the two variables using Excel. Paste the plot here and format it into an APA-styled "figure" (see Assignment Guides for APA format). Be sure to submit the Excel file that you used to create the scatter plot. (2 points)
b. Calculate the mean and standard deviation for the two variables separately.
c. Calculate the Z scores for all the scores of the two variables, separately.
Tips: It may help to prevent error and to increase clarity if the process and/or the answers (z scores) are listed in a table format.
Subject ID education memory
1 16 112
2 16 117
3 12 96
4 17 114
5 16 106
6 14 80
7 14 89
8 12 94
9 16 113
10 13 111
11 16 112
12 18 84
13 12 108
14 16 95
15 12 117
16 14 83
17 8 106
18 12 100
19 18 120
20 14 103
21 14 89
22 12 94
23 14 113
24 12 111
25 12 108