Student Performance Analysis

Spearman rank correlation



                    SPEARMAN RANK CORRELATION


                                      Score1     Rank1    Score2     Rank2
     1   OSBORNE Z                    114.00     14.00     52.00      1.00
     2   BRAINS A                     119.00      8.00     51.33      2.00
     3   LINTON C                     115.00     13.00     48.67      4.00
     4   WHITE O                      127.00      4.00     48.67      4.00
     5   LAMONT B                     105.00     19.50     48.67      4.00
     6   FRANKS M                     130.00      1.50     48.00      6.00
     7   ROLLANDS Z                    95.00     33.00     44.67      7.00
     8   CHERRY B                     129.00      3.00     44.00      8.00
     9   SAINT G                      130.00      1.50     43.60      9.50
    10   ALLEN T                      118.00      9.50     43.60      9.50
    11   CLAYTON Y                    118.00      9.50     43.33     11.00
    12   HOOPER D                      96.00     32.00     42.67     12.00
    13   HOPPERMAN K                  117.00     11.00     42.40     13.00
    14   GILMAN W                     104.00     21.00     42.25     14.00
    15   HILLMAN M                    102.00     26.00     42.00     16.00
    16   ROSSER P                     124.00      5.00     42.00     16.00
    17   GOODYEAR T                   103.00     23.00     42.00     16.00
    18   HOCKEY B                     102.00     26.00     41.33     18.00
    19   WHITTLE P                    100.00     28.00     40.67     20.00
    20   STONE R                      108.00     16.50     40.67     20.00
    21   CARTER J                     109.00     15.00     40.67     20.00
    22   CARSON J                      97.00     30.00     39.33     22.00
    23   PLUMBER G                     97.00     30.00     38.67     23.00
    24   SMYTHE S                     123.00      6.00     37.33     25.00
    25   NICHOLAS M                   102.00     26.00     37.33     25.00
    26   BORN F                        94.00     35.00     37.33     25.00
    27   COURT T                      106.00     18.00     36.67     28.50
    28   RENDALL M                    103.00     23.00     36.67     28.50
    29   FAIRY Q                       94.00     35.00     36.67     28.50
    30   EBBER M                       88.00     38.50     36.67     28.50
    31   FOUNDER M                    122.00      7.00     34.67     32.00
    32   PANE P                       116.00     12.00     34.67     32.00
    33   GUNNER S                     103.00     23.00     34.67     32.00
    34   BRENNEN T                     97.00     30.00     34.00     34.00
    35   CAROL C                       94.00     35.00     31.33     35.50
    36   PARSON T                     105.00     19.50     31.33     35.50
    37   OSMOND L                     108.00     16.50     30.67     37.00
    38   BEATTY M                      91.00     37.00     30.00     38.50
    39   HODDER A                      88.00     38.50     30.00     38.50
    40   DAVIES P                      85.00     40.00     22.89     40.00


     The Correlation factor is  0.54
     The Indicator Median is  104.50       Mean is                  106.95
     Indicator Mode is        103.00       Frequency is               3.00
     The Outcome Median is     40.67       Mean grade / pupil is     39.62
     Outcome mode is           36.67       Frequency is               4.00
     Mean points / pupil is   358.60       The number of pupils is      40





This table shows the pupils listed in rank positions according to their performance in the examinations. Against each pupil is shown their indicator score and rank position according to that score, then their examination mean performance and their rank position according to that.

At the end of the list is the co-efficient of correlation between the indicator score and the examination mean result. This co-efficient should be checked against statistical tables to make sure it is statistically significant, particularly if you are using an untried indicator.

Figures are also given for the Indicator score Mean, Mode and Median values. These can give some idea of the distribution of the indicator scores. Beware of putting too much weight on the Modal score as it is possible to have a number of modes within any sample.
Remember, the Mode score is the most commonly occurring score, the Median represents the mid-range score and the Mean is the average score calculated by summing the individual scores and dividing by the number of individuals.

The same figures are also shown for the outcome score, be this GCSE mean grade or A level points.

Providing the correlation is good, this table is very useful for one can run down the list and see at a glance whether pupils have performed as you would have expected them to, better or worse, by looking at their respective rankings for the indicator and the examination performance.

For instance, a pupil who was ranked 33rd on the indicator score but was ranked 7th on the examination results has shown considerable improvement and vice versa. An alternative hypothesis would be that for the individual pupil the indicator result was not typical and therefore this would highlight the need for the use of other tests to act as a check.

An additional point worth noting here is that it may be the examination mean that is not indicative of the pupil's ability. The mean can be distorted by a rogue result caused by illness, or a personality clash with a particular subject teacher, or the fact that the pupil only took a very few examinations, so check what each pupil actually achieved as shown on the sheet listing the actual grades obtained.


For more information about this site, Tel. 01963 34128 or E-mail: info@bstubbs.co.uk


SPA Home page
Further GCSE analyses
A-level analyses