I'm completly new to speadsheets and have beem asked to compare my subject (I'm a teacher) to another's results.
I just want to be able to get the:
- percentages of A-Bs and A-Cs etc per the two classes
- if possible, highlight where my subject was higher/lower than the other results for that student (I've removed the names column for purpose of showing my data)
I am using numbers 3.1 on my Mac. I'm sure there is most likley a very simple way to do this, but I am very unfamilar in the world of spreadsheets!
Can any offer any much-appreciated help?
Ok, here are some ideas.
The Data table is just data, no formulas.
The Count table counts the occurrences of each grade.
You list the possible grades in column A.
Then in B2, you try a formula like this:
In the formula editor it will look like this:
If it gives you the result you expect, then copy it down and right in that table.
Add a Footer Row at the bottom.
In the cells there put =SUM(B) and =SUM(C)
Then set up a Percentage table:
The formula in B2 there would be
Copy that to the other cells in that table.
Make sure the shaded rows are defined as Header row.