5 Replies Latest reply on Sep 6, 2018 8:53 PM by Shinichiro Murakami

    Comparison groups

    Tony Alderton



      I don't have a workbook to share at this stage. I am just thinking about doing something and would appreciate some advice.


      I have data for 260 schools, and I want to compare each school to a group of nine others based on its total enrolments i.e. school A compared to another nine schools who most closely match school A in terms of the number of enrolments.

      Once we have established each group (and of course each school could be a member of more than one group) I then want to be able to compare each school's performance on other measures (such as student exam results) to the group (of which it is a member) as a whole.


      Any ideas anyone?