Can you help me to see if I did this correctly?

Q1. Pearson's Correlation (15 points) (Round calculated results to the hundredth (2^nd place to the right of the decimal) when result extends beyond that unless otherwise noted).

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.

Subject ID	Education	Z Score x(edu)	memory	Z Score y(mem)	(X*y)
1	12	-0.298342541	112	1.165668663	-0.35
2	13	-0.022099448	117	1.664670659	-0.50
3	12	-0.298342541	96	-0.431137725	0.13
4	12	-0.298342541	114	1.365269461	-0.41
5	16	0.806629834	111	1.065868263	-0.32
6	13	-0.022099448	85	-1.528942116	0.46
7	13	-0.022099448	89	-1.129740519	0.34
8	12	-0.298342541	94	-0.630738523	0.19
9	13	-0.022099448	113	1.265469062	-0.38
10	14	0.254143646	105	0.467065868	-0.14
11	18	1.359116022	112	1.165668663	-0.35
12	10	-0.850828729	84	-1.628742515	0.49
13	10	-0.850828729	90	-1.02994012	0.31
14	16	0.806629834	89	-1.129740519	0.34
15	18	1.359116022	117	1.664670659	-0.50
16	14	0.254143646	83	-1.728542914	0.52
17	12	-0.298342541	106	0.566866267	-0.17
18	12	-0.298342541	89	-1.129740519	0.34
19	16	0.806629834	120	1.964071856	-0.59
20	13	-0.022099448	104	0.367265469	-0.11
21	14	0.254143646	89	-1.129740519	0.34
22	12	-0.298342541	94	-0.630738523	0.19
23	10	-0.850828729	97	-0.331337325	0.10
24	10	-0.850828729	90	-1.02994012	0.31
25	12	-0.298342541	108	0.766467066	-0.23

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)

M = X/N SD = [(X-M)2]/N

Education:M= (Sum)327/(total) 25=13.08 SD= 327/25=3.62

Memory: M: 2508/25= 100.32 SD= (Sum)2508/(total)25= 10.02

c. Calculate the Z scores for all the scores of the two variables, separately. (2 points total: 1 for Z scores for each 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. -Excel data sheet for Q2-

Education	Z Score x	Memory	Z Score y	(X*y)
12	-0.2983425	112	1.1656687	-0.35
13	-0.0220994	117	1.6646707	-0.50
12	-0.2983425	96	-0.4311377	0.13
12	-0.2983425	114	1.3652695	-0.41
16	0.80662983	111	1.0658683	-0.32
13	-0.0220994	85	-1.5289421	0.46
13	-0.0220994	89	-1.1297405	0.34
12	-0.2983425	94	-0.6307385	0.19
13	-0.0220994	113	1.2654691	-0.38
14	0.25414365	105	0.4670659	-0.14
18	1.35911602	112	1.1656687	-0.35
10	-0.8508287	84	-1.6287425	0.49
10	-0.8508287	90	-1.0299401	0.31
16	0.80662983	89	-1.1297405	0.34
18	1.35911602	117	1.6646707	-0.50
14	0.25414365	83	-1.7285429	0.52
12	-0.2983425	106	0.5668663	-0.17
12	-0.2983425	89	-1.1297405	0.34
16	0.80662983	120	1.9640719	-0.59
13	-0.0220994	104	0.3672655	-0.11
14	0.25414365	89	-1.1297405	0.34
12	-0.2983425	94	-0.6307385	0.19
10	-0.8508287	97	-0.3313373	0.10
10	-0.8508287	90	-1.0299401	0.31
12	-0.2983425	108	0.7664671	-0.23

d. Calculate Pearson's correlation coefficient r. (2 points total: 1 for the products of pairs of scores, 1 for the calculation of r)

r= = = 0

e. Explain the direction and strength of the relationship based on the r. (1 point total: .5 for strength, .5 for direction)

Pearson's correlation coefficient value, r= 0 which means there is no correlation and has no relationship.

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?) (Do not round during the calculation, the final result as the percentage should be to the hundredth [2^nd decimal]) (1 point total: -.5 if the process is correct but the answer is wrong)

r²= 0²= 0 ?

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 a p value of .194. 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)