Dec 13 2021 09:13 AM
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?
Dec 13 2021 09:27 AM - edited Dec 13 2021 09:28 AM
"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.
Dec 13 2021 09:33 AM
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 |
Dec 13 2021 12:15 PM
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.