Question: A regional education authority is responsible for ranking the performance of secondary schools over which it has authority. Schools are ranked on a number of factors. These are:

1. the school’s ability to retain its students (i.e a low drop-out rate)
2. post-secondary participation (i.e. the proportion of graduates who go on to college or university)
3. the performance of each school’s graduates when they get to post-secondary institutions
4. academic achievement on examinations
   There are 71 schools in the authority and the ranks for each are presented below.

   School #	Retention rank	Post-secondary participation rank	Post-secondary achievement rank	Academic achievement rank
   1	17	29	51	28
   2	25	51	48	62
   3	29	52	66	69
   4	52	65	25	24
   5	65	60	50	34
   6	53	61	56	64
   7	48	66	30	6
   8	33	70	23	27
   9	16	45	57	21
   10	12	34	63	66
   11	3	1	2	2
   12	18	9	20	32
   13	22	2	45	31
   14	34	5	5	56
   15	61	50	44	9
   16	32	36	10	51
   17	4	40	14	15
   18	23	63	59	65
   19	27	25	55	49
   20	8	4	1	1
   21	59	31	32	36
   22	67	39	27	33
   23	56	33	61	63
   24	21	37	17	43
   25	24	3	36	45
   26	54	62	68	68
   27	1	21	29	12
   28	47	67	34	40
   29	39	44	3	14
   30	46	43	37	54
   31	13	22	58	46
   32	15	35	21	17
   33	19	17	26	4
   34	10	12	13	8
   35	58	41	43	44
   36	2	14	31	60
   37	64	47	40	52
   38	51	15	42	48
   39	62	11	70	70
   40	40	19	7	3
   41	68	16	18	10
   42	31	28	28	47
   43	66	48	35	42
   44	38	69	12	18
   45	26	57	52	16
   46	11	8	46	55
   47	42	10	62	13
   48	14	7	65	59
   49	30	42	41	37
   50	55	18	69	61
   51	37	23	67	50
   52	36	27	9	20
   53	49	26	54	67
   54	50	56	53	41
   55	70	32	33	35
   56	41	55	16	30
   57	9	13	4	19
   58	43	46	15	29
   59	60	58	38	22
   60	45	49	47	39
   61	35	54	6	11
   62	28	53	39	7
   63	44	59	19	38
   64	20	20	22	5
   65	69	24	11	23
   66	57	30	49	26
   67	5	68	60	58
   68	7	38	8	53
   69	6	6	64	57
   70	63	64	24	25

   
   Required
   1. Calculate Spearman’s rank correlation for Retention rank and Post-Secondary Participation rank.
   2. Calculate Spearman’s rank correlation for Post-Secondary Achievement rank and Academic Achievement rank on exams.
   3. Calculate Spearman’s rank correlation for Post-Secondary Participation rank and Post-Secondary Achievement rank.
   4. Comment on your results.

Price: $2.99

Solution: The downloadable solution consists of 6 pages
Deliverable: Word Document