What does Star Ratings, Self-Selection and Bayesian Ranking conclude, in numbers, about “The Wilson Lower Bound: Why Three Five-Star Reviews Rank Below Two Hundred at 4.6”?

Answer: Chapter 3 sorts by the Wilson lower bound: 0.4385 for three five-star reviews against 0.8859 for two hundred at 4.6, while the textbook Wald interval can cover the truth as rarely as 0.049 at small samples and high shares.

Scope of the numbers: Chapter 1 explains the J-shaped star distribution with two filters, a purchasing bias and an under-reporting bias; with illustrative parameters the purchasing bias lifts the mean by +0.532 stars. Marked boxes separate published evidence, runnable Python calculations (21 programs), classical sources and the author's hypotheses.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 0.4385, 0.8859, 200, 4.6

listingnmeanposLB z95LB z90
A: 3 x five35.0001.0000.43850.5258
B: 200 @ 4.62004.6000.9300.88590.8942
C: 12 x five125.0001.0000.75750.8160
D: 40 @ 4.8404.8000.9500.83500.8597
an all-positive listing needs n >= 30 to pass B at z95
an all-positive listing needs n >= 23 to pass B at z90
closed form for all-positive: LB = n / (n + z^2), z^2 = 3.8415
Show the full program
# Chapter 3. p31: Wilson's lower bound puts 200 reviews at 4.6 above 3 fives.
# Wilson (1927) score interval for a binomial share p from k of n:
#   (p + z^2/2n - z sqrt(p(1-p)/n + z^2/4n^2)) / (1 + z^2/n).
# A review counts as positive when it gives 4 or 5 stars. Listing B is a
# constructed example whose 200 reviews average exactly 4.6.
import math

Z95 = 1.959964      # two-sided 95 percent
Z90 = 1.644854      # one-sided 95 percent, also used by some shops


def wilson_lb(k, n, z=Z95):
    if n == 0:
        return 0.0
    p = k / n
    a = p + z * z / (2 * n)
    b = z * math.sqrt(p * (1 - p) / n + z * z / (4 * n * n))
    return (a - b) / (1 + z * z / n)


def mean_star(c):
    return math.fsum((i + 1) * x for i, x in enumerate(c)) / math.fsum(c)


LISTINGS = (
    ("A: 3 x five", (0, 0, 0, 0, 3)),
    ("B: 200 @ 4.6", (5, 2, 7, 40, 146)),
    ("C: 12 x five", (0, 0, 0, 0, 12)),
    ("D: 40 @ 4.8", (0, 1, 1, 3, 35)),
)
print("%-14s %4s %6s %6s %8s %8s" % (
    "listing", "n", "mean", "pos", "LB z95", "LB z90"))
for name, c in LISTINGS:
    n = int(math.fsum(c))
    k = c[3] + c[4]
    print("%-14s %4d %6.3f %6.3f %8.4f %8.4f" % (
        name, n, mean_star(c), k / n, wilson_lb(k, n),
        wilson_lb(k, n, Z90)))
target = wilson_lb(186, 200)
need = 1
while wilson_lb(need, need) <= target:
    need += 1
print("an all-positive listing needs n >= %d to pass B at z95" % need)
need90 = 1
while wilson_lb(need90, need90, Z90) <= wilson_lb(186, 200, Z90):
    need90 += 1
print("an all-positive listing needs n >= %d to pass B at z90" % need90)
print("closed form for all-positive: LB = n / (n + z^2), z^2 = %.4f"
      % (Z95 * Z95))

Single source and citation

Fan, Y. (2026). J-Shaped Self-Selection in Star Ratings, Bayesian-Average Ranking and Rating Inflation from the Nine-Rank System to Online Marketplaces (Version 1.0.0), Chapter 3: The Wilson Lower Bound: Why Three Five-Star Reviews Rank Below Two Hundred at 4.6. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-212 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026212,
  author    = {Fan, Yafu},
  title     = {J-Shaped Self-Selection in Star Ratings, Bayesian-Average Ranking and Rating Inflation from the Nine-Rank System to Online Marketplaces},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book