Hi,
I have created a spreadsheet that calculates the average score of something to give a number, the table below is in a sperate tab, so if the number is between 0 and 1.75 I need the look up to bring back prior attainment group 1, similarly if the average score is 1.75 to 1.99 I need it to being back 2........ there are 19 different averages (I only copied the top 4) and Im not sure how exactly is the best way to work out the formula?
I have created a spreadsheet that calculates the average score of something to give a number, the table below is in a sperate tab, so if the number is between 0 and 1.75 I need the look up to bring back prior attainment group 1, similarly if the average score is 1.75 to 1.99 I need it to being back 2........ there are 19 different averages (I only copied the top 4) and Im not sure how exactly is the best way to work out the formula?
Prior Attainment Group | KS1 Average points score | Average KS2 Reading Score for PAG | Average KS2 Writing Score for PAG | Average KS2 Maths Score for PAG |
1 | 0 to <1.75 | 63.01 | 62.82 | 63.15 |
2 | >=1.75 to<2 | 67.27 | 66.68 | 67.89 |
3 | >=2 to <2.25 | 70.64 | 70.1 | 71.45 |
4 | >=2.25 to <2.5 |