Correlation Table

I want to determine with students who viewed 7 zoom recordings, worth 10 points each, scored higher on their final exams. So, I guess the question is: does watching the zoom recordings increase fina...

excel

training

katejohn1260

Copper Contributor

Dec 13, 2021

SergeiBaklan

Maybe I am asking the question wrong. I want to know, if possible, if the completed zoom quizzes (10 points) had a positive correlation on the final grade>

Module 1 Zoom	Module 2 Zoom	Module 3 Zoom	Module 4 Zoom	Module 5 Zoom	Module 6 Zoom	Module 7 Zoom	Final Exam
10	10	10	10	10	10	10	100
10	10	10	10	10	10	10	88
10	10	10	10	10	10	10	86
10	10	10	0	10	0	0	0
10	10	10	10	10	10	10	80
10	10	10	10	10	10	10	74.99
10	10	10	10	10	10	10	93.67
10	10	10	10	10	10	10	94.67
10	10	10	10	10	10	10	92.75
10	10	10	10	10	10	10	0
10	10	10	10	10	10	10	83.83
10	10	10	10	10	10	10	84
0	0	0	0	0	0	0	0
10	10	10	10	10	10	10	95.17
10	10	10	10	10	10	10	96
10	10	10	10	10	10	10	93.25
10	10	10	10	10	10	10	91.75
10	10	10	10	10	10	10	0
10	0	10	10	10	10	10	81.83
10	10	10	10	10	10	10	95.08
10	10	10	10	10	10	10	0
10	10	10	10	10	10	10	97.17
0	0	0	0	0	0	0	0
10	10	10	0	0	0	0	93
10	10	10	10	10	10	10	96.5
10	10	10	10	10	0	0	0
10	10	10	0	0	0	0	0
10	10	10	10	10	10	10	52
10	10	10	10	10	10	10	100
10	10	0	0	0	0	0	29.5
10	10	10	10	10	10	10	88.5
0	0	0	0	0	0	0	0
10	10	0	0	0	0	0	0
10	0	0	0	0	0	0	0
10	10	0	0	0	0	0	0
10	10	10	10	10	10	10	92.33
10	10	10	10	10	10	10	86
10	0	0	0	0	0	0	69.75

SergeiBaklan

Diamond Contributor

Dec 13, 2021

katejohn1260

I see, thank you. Stats is not my territory, but in general any two arrays have some correlation, the question is how to interpret it, is it good or bad. You may play with data, for example

shows some correlation.

Perhaps someone else who is more familiar with statistics could give more professional answer.

exam correlation to zoom.xlsx18 KB

Forum Discussion

Correlation Table

Resources