I then want to "spread" the population i each municipality next year according to the school-preference in Table1. This means i have to calculate the percentage per school per municipality (each municipalyt should sum to 100%) from Table1, and then multiply each school-percentage with the expected population next year in the relevant municipality from Table2. The result should than be a Table3 with the four Mnr vertically and the four schools horisontally, populated with the number of students based on the population next year.
I want to do this in a set analysis. How can i do this?
Currently there are 31 students in Mnr = 1 and next year you will have 35. So, based on the percentage for S1 = 18/31, you expect to see 18*35/31 = 20 students or 21 students because the number that you get is in decimals (20.32258)