A group of 8 cybersecurity analysts (A, B, C, D, E, F, G, and H) completed a high-stakes penetration testing simulation. Their efficiency scores, where a higher score indicates better performance, are recorded in the table below.
| Analyst | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| Efficiency Score | 82 | 45 | 78 | 94 | 36 | 61 | 89 | 52 |
The analysts were also ranked by their years of industry seniority. The list below shows the analysts in order from most senior (rank 1) to least senior (rank 8):
G,D,A,F,C,B,H,E G, \quad D, \quad A, \quad F, \quad C, \quad B, \quad H, \quad E G,D,A,F,C,B,H,ECalculate Spearman's rank correlation coefficient between the analysts' efficiency scores and their seniority ranks.
Stating your hypotheses clearly, test at the 5% level of significance whether there is evidence of a positive correlation between seniority and performance efficiency.
The analysts' annual salaries were also recorded. In this dataset, several analysts earned the exact same salary. Explain how you would calculate the Spearman's rank correlation coefficient between efficiency scores and salaries in the presence of these tied values.
Practise Edexcel A Level Maths Measuring Correlation with exam-style questions for A Level Maths. 108 questions, matched to the Edexcel A Level Maths (9MA0) specification and written in Paper 1, Paper 2 and Paper 3 style. Every question includes a full worked solution and mark scheme, so you can see where marks are awarded rather than just whether you got the answer right.
