Correlation Table

New Contributor

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 final grades?

3 Replies

@katejohn1260 

"does watching the zoom recordings increase final grades?" - that only you know, are you willing to increase final grade or not.

 

If the question is how to calculate final grades in Excel based on other data (zoom recordings, etc) it's better to submit small sample file which illustrates which data do you have and how it structured with desired final result added manually.

@Sergei Baklan 

 

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 ZoomModule 2 Zoom Module 3 Zoom Module 4 Zoom Module 5 Zoom Module 6 Zoom Module 7 Zoom Final Exam 
10101010101010100
1010101010101088
1010101010101086
101010010000
1010101010101080
1010101010101074.99
1010101010101093.67
1010101010101094.67
1010101010101092.75
101010101010100
1010101010101083.83
1010101010101084
00000000
1010101010101095.17
1010101010101096
1010101010101093.25
1010101010101091.75
101010101010100
100101010101081.83
1010101010101095.08
101010101010100
1010101010101097.17
00000000
101010000093
1010101010101096.5
1010101010000
10101000000
1010101010101052
10101010101010100
10100000029.5
1010101010101088.5
00000000
1010000000
100000000
1010000000
1010101010101092.33
1010101010101086
1000000069.75

@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

image.png

shows some correlation.

 

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