What does Extreme Tails and Chargeback Reserves conclude, in numbers, about “Return Levels: How Large Is the Whale Order That Comes Once in So Many Months”?

Answer: Chapter 4 turns parameters into return levels: the exact once-in-ten-years whale order is 27214 yuan where the normal estimate is only 1459, and a once-in-ten-years event occurs within ten years with probability 0.632.

Scope of the numbers: Chapter 5 chooses the threshold with the mean excess plot and 150 simulated shops; the log error of the ten-year level is smallest at the ninetieth percentile, at 0.194. Marked boxes separate published evidence, runnable Python calculations (19 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: 1459, 27214

43200 orders, u 626.7, 2159 excesses, lam 89.96 a month
PWM xi 0.316 sigma 295.8; mean 238.1 sd 275.4
T(months) GPD90% interval exact normal
13569 3276 to 3866 4005 1136
128195 6895 to 9741 10833 1315
6013831 10880 to 17521 20624 1417
12017293 13234 to 22501 27214 1459
bootstrap 90% interval of xi0.269 to 0.362
Show the full program
# Chapter 4. p41: return levels for the whale order, with intervals.
# Model: 24 months of 1,800 orders a month from the illustrative Burr
# XII law (b = 200, c = 2, k = 1.25), fixed seed. Threshold u = top 5%,
# PWM fit, lam = exceedances per month. T-month return level (the size
# exceeded once per T months on average):
#   x_T = u + sigma / xi * ((lam T) ** xi - 1).
# 90% interval by a parametric bootstrap (400 refits, fixed seed),
# set beside the exact Burr value and the normal (mean, sd) value.
# The parent's limiting tail shape is 0.4 (illustrative).

import math
import random
from statistics import NormalDist

B, C, K = 200.0, 2.0, 1.25
PER, MONTHS = 1800, 24
ND = NormalDist()


def burr_q(p):
    return B * ((1.0 - p) ** (-1.0 / K) - 1.0) ** (1.0 / C)


def gpd_pwm(y):
    ys = sorted(y)
    n = len(ys)
    a0 = math.fsum(ys) / n
    a1 = math.fsum(v * (n - 1 - j) / (n - 1) for j, v in enumerate(ys)) / n
    xi = 2.0 - a0 / (a0 - 2.0 * a1)
    return xi, 2.0 * a0 * a1 / (a0 - 2.0 * a1)


def level(u, xi, sig, lam, t):
    return u + sig / xi * ((lam * t) ** xi - 1.0)


def pct(xs, p):
    ys = sorted(xs)
    return ys[min(len(ys) - 1, int(p * len(ys)))]


rng = random.Random(20261119)
n = PER * MONTHS
xs = sorted(burr_q(rng.random()) for _ in range(n))
u = xs[int(0.95 * n)]
y = [x - u for x in xs if x > u]
lam = len(y) / MONTHS
xi, sig = gpd_pwm(y)
m = math.fsum(xs) / n
sd = math.sqrt(math.fsum((x - m) ** 2 for x in xs) / (n - 1))
print("%d orders, u %.1f, %d excesses, lam %.2f a month"
      % (n, u, len(y), lam))
print("PWM xi %.3f sigma %.1f; mean %.1f sd %.1f" % (xi, sig, m, sd))
boot = []
for _ in range(400):
    yb = [sig / xi * ((1.0 - rng.random()) ** (-xi) - 1.0) for _ in y]
    boot.append(gpd_pwm(yb))
print("  T(months)    GPD    90% interval       exact   normal")
for t in (1, 12, 60, 120):
    est = level(u, xi, sig, lam, t)
    bs = [level(u, a, b, lam, t) for a, b in boot]
    exact = burr_q(1.0 - 1.0 / (PER * t))
    normal = m + sd * ND.inv_cdf(1.0 - 1.0 / (PER * t))
    print("  %6d   %7.0f  %7.0f to %7.0f  %7.0f  %7.0f"
          % (t, est, pct(bs, 0.05), pct(bs, 0.95), exact, normal))
lo, hi = pct([a for a, _ in boot], 0.05), pct([a for a, _ in boot], 0.95)
print("bootstrap 90%% interval of xi: %.3f to %.3f" % (lo, hi))

Single source and citation

Fan, Y. (2026). Extreme-Value Theory and Generalised Pareto Tails: Whale-Order Ceilings and Reserves for Extreme Chargebacks (Version 1.0.0), Chapter 4: Return Levels: How Large Is the Whale Order That Comes Once in So Many Months. 5D Library. DOI pending

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

BibTeX
@book{fan2026244,
  author    = {Fan, Yafu},
  title     = {Extreme-Value Theory and Generalised Pareto Tails: Whale-Order Ceilings and Reserves for Extreme Chargebacks},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book