D
Dave Lester
Every year my work colleagues and I do a Premier league football
prediction game, in that you have to predict the final league table i.e
Arsenal 1st, Chelsea 2nd etc Points are awarded for how accurate peoples
predictions are i.e 5 points for spot on, 4 points for one away, 3
points for 2 away etc.
I've been doing the calculations by hand but it's a time consuming
business. How would it be done on excel?
I assume that you have to assign values to the actual league Arsenal=1,
Chelsea=2 etc and values to the forecast then do a sum of the
differences, but how?
TIA
Dave Lester
prediction game, in that you have to predict the final league table i.e
Arsenal 1st, Chelsea 2nd etc Points are awarded for how accurate peoples
predictions are i.e 5 points for spot on, 4 points for one away, 3
points for 2 away etc.
I've been doing the calculations by hand but it's a time consuming
business. How would it be done on excel?
I assume that you have to assign values to the actual league Arsenal=1,
Chelsea=2 etc and values to the forecast then do a sum of the
differences, but how?
TIA
Dave Lester