Data set attached in screen shot

Q1. Pearson's Correlation (20 points)

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. Make a scatter plot between the two variables using Excel. Paste the plot here and format it into an APA "figure"

- .5 for correct scatter graph type

- .5 for the two axis labels (deduct .5 even if only one label is missing)

- .5 for APA figure label and number

- .5 for figure caption

- 1 for correct data from the two variables on the X and Y axes

b. Calculate the mean and standard deviation for the two variables separately.(4 points total: 1 point for each mean and 1 point for each SD, deduct .5 if an answer is incorrect but the calculation process was correct)

c. Calculate the Z scores for all the scores of the two variables, separately.(4 points total: 2 for the Z scores for each variable, deduct .5 for each error in the Z scores up to a total of 2 per variable)

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.

d. Calculate Pearson's correlation coefficientr.(2 points total: 1 if the process is correct but the answer is wrong)

e. Explain the direction and strength of the relationship based on ther.(2 points total: 1 for strength, 1 for direction)

f. What is the proportion of variance shared between the two variables? (That is, how much of the variance in one variable can be predicted by the variance in the other variable?)(2 points total: 1 if the process is correct but the answer is wrong)

g. If the researcher wants to perform a two-tailed hypothesis test using this data set so that she can generalize the relationship between the two variables from the sample to the population, what would be the null and alternative hypothesis? Write the hypotheses in words and in symbol notation.(2 points total: 1 for each hypothesis, .5 for written, .5 for symbol notation)

h. Using SPSS to analyze the same dataset yields apvalue of .245. Based on? = .05, what would be the conclusion of the hypothesis test (use wording of "reject the null hypothesis" or "fail to reject the null hypothesis"? How do you know?(1 point total: .5 for conclusion, .5 for rationale)

Excel File Edit View Insert Format Tools Data Window Help 78% Mon 3:14 PM Q DE . . . coursehero.com O AutoSave OFF THE6 7 PSY230-M6Assignment-Data-FallB2019 @ v S AA AA Meetings - In... Birmingham, AL... Eating Disorders... + Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 AA = do v % Conditional Formatting O . Paste BIUV Number Format as Table Cell Styles v Cells Editing Ideas B2 4 X V fx 16 A B D E F G H K L M N 1 Subject ID education memory S D O J O L A W N F O LO OO V O UT A W N 16 112 18 117 14 96 114 106 80 89 12 94 18 113 111 12 84 108 95 17 83 Iderly residents in a community to 106 factor against dementia, and LOO vel (measured in number of years of 120 103 rly residents. re" Q1 Q2 + " - + 100% Find Lc. Wa Accent. 2.956 28 tv X W