the average for frequency data is calculated as follows:
set up a table as shown below:
category weight rating weight * rating
promptness 2 2 4
record keeping 4 7 28
appearance 1 2 2
bedside manner 3 3 9
total 10 n/a 43
you multiply the rating by the weight to get the weight * rating.
you then add up all the weight * rating scores.
you then add up all the weight scores.
you then divide the sum of the weight * rating scores by the sum of the weight scores to get the average.
the sum of the weight * rating scores was 43.
the sum of the weight scores was 10.
the average was 43 / 10 = 4.3
the weighting factor of each category is equivalent to the frequency of each category.
here's a reference that talks about finding the average of a frequency table.
https://www.mathsisfun.com/data/mean-frequency-table.html