Looks easy, but I could not do it.
For example, if I have a frequency distribution like:
Class - Frequency - Sum
A - 1 - 150
B - 2 - 200
A - 3 - 450
B - 4 - 400
The challenge: using Pivot Tables, how can I calculate the average of 'sum' by classes?
The answer should be:
Average A = 150
Average B = 100
Thanks!
For example, if I have a frequency distribution like:
Class - Frequency - Sum
A - 1 - 150
B - 2 - 200
A - 3 - 450
B - 4 - 400
The challenge: using Pivot Tables, how can I calculate the average of 'sum' by classes?
The answer should be:
Average A = 150
Average B = 100
Thanks!