Question

What is the p value for the correlation and what does it mean?

students	AS	G
1	8	81
2	9	97
3	8	72
4	7	79
5	6	70
6	4	60
7	6	81
8	7	87
9	6	77
10	0	85
11	6	64
12	7	91
13	8	75
14	7	73
15	7	76
16	8	83
17	8	83
18	2	55
19	8	92
20	9	92
21	8	90
22	7	62
23	9	85
24	7	57
25	5	82
26	9	91
27	8	69
28	5	66
29	9	88
30	8	74

Answer 1

Bring the above data in to excel sheet. Please follow the step by step procedure to find correlation and P value. Next to find whether the P value is statistically significant or not.

1. Go to data --> data analysis --> choose regression statistics.

2. input Y range and X range , and finally choose output range then click ok.

3. Regression output will be populated in excel sheet.

4. There is a "Multiple R " value in the first row will be the correlation value.

5. Correlation = Multiple R value

6. Directly without statistics also we can find correlation value with excel formula "=CORREL(Variable 1, Variable 2)

7. Inthe above image highlighted P value and Significance F. Both are same in the regression statistics.

8. Now we need to find P value rules.

9. The P-value is the probability that you would have found the current result if thecorrelation coefficient were in fact zero (null hypothesis). If this probability is lower than the conventional 5% (P<0.05) the correlation coefficient is called statistically significant.

10. Our P value is 0.014 < 0.05. So statistically significant