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 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

Subject ID education memory 16 112 16 117 12 96 17 114 16 106 14 80 14 89 12 94 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