How to calculate the overall rating of a review?

Question

Mathematics

Hello everyone, tell me how to calculate the overall rating for reviews, not exceeding 5 points?
For example, there is an iPhone 8 product that has 3 reviews according to the criteria: Price, Quality.
First review: Price = 4, Quality = 5
Second review: Price = 1, Quality = 2
Third review: Price = 5, Quality = 5
The total amount of criteria and the number of reviews are recorded in the database for a product record, for example:
review_count = 3
rating_summ = 22
It is necessary to calculate the total sum of the rating by review_count and rating_summ, not exceeding 5 points

Answer 1

Well, if the criteria have equal weights, then calculate the arithmetic mean of all the criteria. If the criteria have weights, calculate the arithmetic weighted average. And then the arithmetic mean of all arithmetic means.
As far as I understand, your weights are equal. Provided that all the criteria are put down in each review, it all comes down to a simple formula:

СУММА_РЕЙТИНГОВ_ВСЕХ_КРИТЕРИЕВ / (КОЛИЧЕСТВО_ОТЗЫВОВ * КОЛИЧЕСТВО_КРИТЕРИЕВ)