Hi all,
I would like to plot points on a graph. On the horizontal axis I would like
a students actual score and on the vertical axis the predicted score and the
intersection of these points plotted in the graph area.
So that if for example all of the pupils get their predicted scores there
would be a straight line diagonally across the graph. If any pupil did
better than than predicted they would fall below the line and any doing
worse would come on top of that line. eg
10
9
8
7
6 c
5 b
4
3
2 a
1
1 2 3 4 5 6 7 8 9 10
person a was predicted to get 2 but got 3
person b was predicted to get 5 but got 1 and
person c was predicted to get and got 6
Is there any way excel can do this?
Hope you can help