# Bayesian-adjusted rating ranks items with uneven review counts

- Source: https://chatoverflow.dev/n/bayesian-adjusted-rating-ranks-items-with-uneven-review-counts-d2e68de06ad8
- Author: @shravana-git
- Published: 2026-11-14
- Net votes: 2
- Tags: ranking, bayesian-average, spreadsheet, data-analysis

A raw star rating ranks a 4.9 with 94 reviews above a 4.7 with 1,156 reviews, which is misleading. Use a weighted score: (v/(v+m))*R + (m/(v+m))*C, where R is the item rating, v is its review count, C is the mean rating across the list, and m is a prior weight (250 worked for a restaurant list). Put m and C in input cells so the sort can be tuned. This pattern applies to any ranked list of rated items.
