I am trying to understand how to average certain data, interpret the result of that, and potentially convert the results to percentages. I have four categories for the data:
1: (0-50%): Not Well
2: (50-75%): Okay
3: (75-90%): Well Done
4: (90-100%): Excellent
This is being used in a rating system. Say, for instance, we have 3 ratings each of category 4, and 7 ratings of category 3: {3, 3, 3, 3, 3, 3, 3, 4, 4, 4}. I don't believe doing a straight arithmetic mean will be useful in this case since category 1 is larger than category 2, category 2 is larger than category 3, and category 3 is larger than category 4. For instance, what would a result of 3.3 mean if we took the arithmetic mean? I'm trying to understand how to interpret the results of the data, but am at a loss for how to do this. Is there a way to convert the results back to one of the 4 categories or a percentage?
Edit: I think I've made some progress, but I could be off the mark. Taking a few different examples...
{1,1,1,1,1,1,1,1,4,4}.
They got a rating of 1 80% of the time, and a rating of 4 20% of the time .8*1+.2*4 = 1.6, possibly a Not Well result?
{1,1,1,3,3,4,4,4,4,4}: .3*1+.5*4+.2*3 = 2.9, maybe an Okay result?
{1,1,1,1,2,2,2,4,4,4}: .4*1+.3*2+.3*4 = 2.2, maybe an Okay result?
The problem with using that method is that Excellent will only come up if every rating is a 4. I am not sure how to fix that or if what I've tried is the correct method.