Question: 3.Finally, the professor is interested in whether there is a relationship between whether or not students' completed the study questions (Questions) and the students' final
3.Finally, the professor is interested in whether there is a relationship between whether or not students' completed the study questions (Questions) and the students' final exam scores (FinalScore). Test whether there is a relationship between these 2 variables by computing a Spearman's rhocorrelation.
a. According to your results, is there a correlation between whether or not students completed the study questions and the students' final exam scores?
b. What is the strength of the relationship and how can you tell?
c. What is the p-value of this correlation (at what level is the correlation significant)?
Spearman Rank Correlation Calculator here - https://www.socscistatistics.com/tests/spearman/
| FinalScore | Questions | COEProgram | Gender | StatView1 | StatView2 | StatView3 | StatComfort | PreScore | Race/Ethnicity |
| 87.00 | 1.00 | 1 | 0.00 | 4.00 | 3.00 | 4.00 | 3.67 | 80.00 | 1.00 |
| 100.00 | 1.00 | 2 | 0.00 | 4.00 | 5.00 | 5.00 | 4.67 | 90.00 | 3.00 |
| 87.00 | 0.00 | 1 | 0.00 | 4.00 | 4.00 | 4.00 | 4.00 | 67.00 | 2.00 |
| 99.00 | 1.00 | 3 | 1.00 | 5.00 | 5.00 | 1.00 | 3.67 | 88.00 | 2.00 |
| 81.00 | 0.00 | 1 | 1.00 | 2.00 | 2.00 | 2.00 | 2.00 | 67.00 | 4.00 |
| 54.00 | 0.00 | 1 | 0.00 | 1.00 | 1.00 | 3.00 | 1.67 | 49.00 | 4.00 |
| 81.00 | 0.00 | 2 | 1.00 | 3.00 | 2.00 | 2.00 | 2.33 | 80.00 | 5.00 |
| 96.00 | 1.00 | 2 | 0.00 | 4.00 | 3.00 | 3.00 | 3.33 | 80.00 | 5.00 |
| 90.00 | 1.00 | 3 | 0.00 | 3.00 | 3.00 | 3.00 | 3.00 | 87.00 | 5.00 |
| 72.00 | 0.00 | 1 | 1.00 | 1.00 | 1.00 | 2.00 | 1.33 | 70.00 | 5.00 |
| 96.00 | 1.00 | 3 | 0.00 | 4.00 | 4.00 | 4.00 | 4.00 | 78.00 | 1.00 |
| 98.00 | 1.00 | 3 | 0.00 | 5.00 | 5.00 | 4.00 | 4.67 | 79.00 | 1.00 |
| 78.00 | 0.00 | 1 | 1.00 | 2.00 | 2.00 | 2.00 | 2.00 | 69.00 | 4.00 |
| 66.00 | 0.00 | 2 | 1.00 | 2.00 | 2.00 | 2.00 | 2.00 | 69.00 | 4.00 |
| 89.00 | 0.00 | 3 | 1.00 | 5.00 | 4.00 | 5.00 | 4.67 | 80.00 | 1.00 |
| 90.00 | 1.00 | 1 | 1.00 | 4.00 | 4.00 | 5.00 | 4.33 | 80.00 | 1.00 |
| 88.00 | 1.00 | 1 | 1.00 | 4.00 | 4.00 | 4.00 | 4.00 | 79.00 | 5.00 |
| 95.00 | 1.00 | 3 | 0.00 | 5.00 | 5.00 | 5.00 | 5.00 | 90.00 | 5.00 |
| 100.00 | 1.00 | 2 | 1.00 | 4.00 | 3.00 | 3.00 | 3.33 | 93.00 | 3.00 |
| 80.00 | 0.00 | 2 | 0.00 | 3.00 | 3.00 | 3.00 | 3.00 | 80.00 | 2.00 |
| 70.00 | 1.00 | 1 | 1.00 | 2.00 | 2.00 | 3.00 | 2.33 | 69.00 | 2.00 |
| 99.00 | 1.00 | 3 | 0.00 | 4.00 | 4.00 | 4.00 | 4.00 | 96.00 | 1.00 |
| 100.00 | 1.00 | 3 | 1.00 | 5.00 | 5.00 | 5.00 | 5.00 | 90.00 | 2.00 |
| 87.00 | 1.00 | 3 | 1.00 | 3.00 | 4.00 | 3.00 | 3.33 | 80.00 | 2.00 |
| 85.00 | 1.00 | 2 | 1.00 | 3.00 | 3.00 | 2.00 | 2.67 | 80.00 | 5.00 |
| 45.00 | 0.00 | 2 | 1.00 | 1.00 | 2.00 | 2.00 | 1.67 | 50.00 | 4.00 |
| 65.00 | 0.00 | 2 | 0.00 | 1.00 | 1.00 | 2.00 | 1.33 | 60.00 | 4.00 |
| 77.00 | 0.00 | 1 | 0.00 | 3.00 | 3.00 | 4.00 | 3.33 | 70.00 | 3.00 |
| 79.00 | 0.00 | 1 | 0.00 | 2.00 | 2.00 | 2.00 | 2.00 | 78.00 | 2.00 |
| 92.00 | 0.00 | 1 | 1.00 | 4.00 | 4.00 | 5.00 | 4.33 | 88.00 | 5.00 |
| #NULL! | #NULL! | #NULL! | #NULL! | #NULL! | #NULL! | #NULL! | #NULL! | #NULL! | #NULL! |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts