The data file Test_Score.xlsx shows mid-term and final grades for 32 students.

1. Calculate the mean and the standard deviation for the midterm and the final.
2. Which variable had more dispersion as measured by the standard deviation.
3. Calculate and interpret the correlation coefficient between the midterm and the final.

Final Midterm 86 78 94 97 83 86 92 89 88 77 75 68 84 68 79 68 95 93 61 89 62 71 98 90 68 80 96 81 96 93 83 93 82 72 100 95 52 91 100 89 80 75 91 86 86 97 36 63 100 99 51 67 98 88 97 97 98 85 43 40 88 72 91 47