Comparing the best product based on responses and rating

[John_W_Excel]

This is more of a general data analysis question in Excel.

Let's say we are analysing three products where customers have provided feedback. We know the product, amount of responses and the rating, as shown in the table below:

Product	Responses	Rating (out of 10)
Product 1	590	6.4
Product 2	140	5
Product 3	88	7

Now, what could we do in Excel to compare the products?

Should we creating a new column called "rating per 100 responses" and use the following formula: (C2/B2)*100.

Would that even be an appropriate way of comparing the data? What else could be done to compare?

 

[maabadi]

Welcome to MrExcel Message Board.
Not. Rating should be compared with togethers and if Responses are more, it is better.
For complex formula for comparing check this:
Algorithm to calculate rating based on multiple reviews (using both review score and quantity)

And for that you should write rates one by one for each Product.