Help Average Ratings

[Baby0920]

If 31 head counts are equivalent to 100%, In performance ratings

Excellent 92%-100%

Good 85%-92%

Basic 84% and below

15 got excellent, 10 got a good rating, and 6 got a basic rating. Given that the excellent rating is higher, the average amount should be higher too. Average rating multiply by weightage of 75%. Please give me an example of computation.

 

[🤖]

To compute the average rating, we need to assign a weightage of 75% to the ratings.

First, let's calculate the total number of head counts:

Total head counts = 15 (excellent) + 10 (good) + 6 (basic) = 31

Next, let's calculate the weighted average rating for each category:

Weighted average for "Excellent" = (15/31) * 100% * 75% = 36.29%
Weighted average for "Good" = (10/31) * 100% * 75% = 24.19%
Weighted average for "Basic" = (6/31) * 100% * 75% = 14.68%

Now, let's calculate the overall average rating:

Overall average rating = Weighted average for "Excellent" + Weighted average for "Good" + Weighted average for "Basic"

Overall average rating = 36.29% + 24.19% + 14.68% = 75.16%

Therefore, the average rating with a weightage of 75% would be approximately 75.16%.