Suppose I recorded the attendance of my students in a recent statistics class because I wanted to

Question:

Suppose I recorded the attendance of my students in a recent statistics class because I wanted to investigate the relationship between the number of classes they missed and their final grades. The following table shows the data for a random sample of nine students. These data can also be found in the Excel file missed classes.xlsx.

a. Calculate the Spearman rank order correlation coefficient.
b. Perform a hypothesis test to determine if the population rank correlation coefficient is less than zero using Î± = 0.05.