Help Percentage Average

[Baby0920]

If 31 head counts are equivalent to 100%, In performance ratings, 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 can assign a numerical value to each rating category. Let's say we assign the following values:

• Excellent: 4
• Good: 3
• Basic: 2

Now, we can calculate the total rating score by multiplying the count of each rating category by its assigned value:

Total rating score = (15 * 4) + (10 * 3) + (6 * 2) = 60 + 30 + 12 = 102

Since we have 31 headcounts equivalent to 100%, we can calculate the rating average by dividing the total rating score by the maximum possible rating score (31 * 4, as the highest rating is excellent):

Rating average = Total rating score / (31 * 4) = 102 / 124 = 0.8226

To account for the weightage of 75%, we multiply the rating average by 0.75:

Weighted rating average = Rating average * 0.75 = 0.8226 * 0.75 = 0.617

So, in this example, the weighted average rating would be 0.617.