Comparing the best product based on responses and rating

John_W_Excel

New Member
Joined
Jan 24, 2021
Messages
1
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:

ProductResponsesRating (out of 10)
Product 15906.4
Product 21405
Product 3887

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?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,130,035
Messages
5,639,668
Members
417,104
Latest member
Nelsini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top