Check my work 8 Suppose Texas A & M University-Commerce has five scholarships available for the women's basketball team. The head coach provided the two assistant coaches with the names of 10 high school players with potential to play at the university. Each assistant coach attended three games and then ranked the 10 players with respect to potential. To explain, the first coach ranked Norma Tidwell 11.11 as the best player among the 10 scouted and Jeannie Black the worst. points Rank, by Assistant Coach Rank, by Assistant Coach Player Jean Cann John Cannelli Player Jean Cann John Cannelli Cora Jean Seiple Candy Jenkins eBook Bette Jones Rita Rosinski Jeannie Black N Anita Lockes Print Norma Tidwell 10 Brenda Towne Kathy Marchal 4 10 Denise Ober References pictureClick here for the Excel Data File Complete the table. (Leave no cells blank - be certain to enter "O" wherever required. Negative amounts should be indicated by a minus sign.) Player Rank by Cann Rank by Cannelli d d-square 5Check my work 8 Complete the table. (Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be indicated by a minus sign.) Rank by d 11.11 Player Rank by Cann Cannelli d-square points 1 1 5 2 3 eBook 3 2 4 10 Print 5 4 10 References 6 9 7 5 8 8 6 CO 8 W 10 7 NCheck my work 8 Reject Ho if t> 11.11 points eBook b-3. Compute the 7 value? (Round test statistic value to 3 decimal places.) Print t = References b-4. At the 0.05 significance level, can we conclude there is a positive association between the ranks? Ho is There is association between the ratings of the two coaches.Check my work 8 a. Determine Spearman's rank correlation coefficient. (Round rank correlation value to 4 decimal places. Negative answer should be indicated by a minus sign.) 11.11 Spearman's coefficient of rank correlation = points eBook Print References b-1. State the null hypotheses and alternate hypotheses. Ho: H1