I have the correct answers but need a detailed explanation on how to manually calculate the answers and specifically what steps are required in calculating the ranks of each of the columns

Use the following information to calculate your answers to questions 15 through 19.

Two faculty members ranked 12 candidates for scholarships.

Candidate	Rank by Professor A	Rank by Professor B	A	B	D	D^2
1	6	5
2	10	11
3	2	6
4	1	3
5	5	4
6	11	12
7	4	2
8	3	1
9	7	7
10	12	10
11	9	8
12	8	9

15. What is the Spearman rank-correlation coefficient (rs)? The correct answer is: 0.87

16. What is rs?The correct answer is: 0.30

17. What is the value of the test statistic z?The correct answer is: 2.88

18. What is the p-value?The correct answer is: 0.004

19. Using = .02 what is your conclusion about how Professor A and Professor B rank the twelve students?The correct answer is: Since the p-value is less than .02 we can conclude that the ranking of the twelve students by Professor A and Professor B are correlated.