I can't be the first to ask this but I have now idea how to word my question correctly. I tried googling but was not successful.
Let's say I have an excel sheet with names of applications. Each row contains, aside from the app name,
- What rating the application has on an app store (0-100 %)
- How many people rated the app
I want to calculate some kind of "hotness" or "popularity" score and sort the apps by this score. I can't just sort them by the rating, because apps that only have 1 rating of 100% would rise to the top, which I don't want. Similarly, if I sort just by the number of rating, bad apps with a lot of rating would rise to the top. I'm interested in seeing apps that are both well rated and have a lot of ratings at the top and the ones that are bad rated or don't have many ratings at the bottom.
I really think this is quite an intuitive question and many people must have encountered this problem. How would I go about solving this? Is there some generally accepted solution? Is there some terminology that I missing that I can google?