I think you had the right idea: beta-binomial is best.
The following parameters match up mean and variance ($\mu=\sigma^2$) like the Poisson:
$$ 0 \lt \alpha = n - 1 - \mu $$
$$ 0 \lt \beta = \frac{\alpha(n-\mu)}{\mu} $$
$$ 1 \le \mu \le n-2 $$
Many other finite discrete distributions cannot support a variance anywhere near the mean value, especially as the mean approaches the maximum.
To support this answer, I define Poisson-like as a value judgment with the following conflicting priorities as measures of similarity between two distributions.
- Target
- Similar mean.
- Statistic
- Similar variance, skewness and kurtosis.
- Process
- Similar constructive assumptions (i.e. like a Poisson process).
- PMF-Shape
- Similar local maximums and similar girth at lower heights.
- PMF-Proportion
- Similar PMF ratio across all matching outcomes.
I would call your initial approach the finite Poisson that does not distinguish the cap outcome from that of greater values or perhaps (the capped-tail Poisson for short) and arguably it immediately has the advantage of similarity in process, PMF-shape, and PMF-proportion as long as we ignore the exceptional point at the cap. The disadvantage (as you have observed) is as the expectation approaches maximum. Here, dissimilarity and control issues prevail such as a falling mean and an exceptionally large probability mass at the cap.
An alternative that removes this exceptional point is what I call the finite Poisson that ignores outcomes above the cap value (or the discounted-tail Poisson for short). Like the capped-tail, the code for a discounted-tail uses the Poisson with special treatment for being out-of-bounds. The only difference is, the program discards and retries until the result is in range. This does well in similarity of process and PMF-proportion, but (relative to the capped-finite Poisson) does worse in the other respects, including shifting the realized mean even lower (relative to a chosen Poisson).
Throwing PMF-shape and PMF-proportion to the back of the line now, (the most intuitive and direct measures of similarity) I can look for a better fit among several distributions by prioritizing similarity of target, statistic and process. Further simplifying, I'll just focus on a mean of 190 with a maximum of 200. In other words, what distributions can I find that looks most like Poisson($\lambda=190$)? Standard of comparison:
- $(\mu, \sigma^2, \frac{\mu_3}{\sigma^3}, \frac{\mu_4}{\sigma^4})=(190, 190, 0.0725, 3.005)$ for the Poisson $(\lambda=190)$
After studying the binomial, the Poisson binomial, and the hypergeometric distributions, I find that the variance is severely limited by the following relation.
$$ \sigma^2 \le \mu \frac{n-\mu}{n}$$
So for comparison:
- Given $n=200$ and mean $\mu=190$, $\sigma^2 \le 9.5$ for any of binomial, hypergeometric or Poisson binomial.
By contrast, the beta-binomial with parameters as mentioned can have identical variance:
- $(\mu, \sigma^2, \frac{\mu_3}{\sigma^3}, \frac{\mu_4}{\sigma^4})=(190, 190.1, -2.329, 10.003)$ for the beta-binomial $(N=200, \alpha=9, \beta=0.474)$
Even with beta-binomial, the match is better for smaller means; see how skewness and kurtosis depart from Poisson as the mean grows.
$$(\mu, \sigma^2, \frac{\mu_3}{\sigma^3}, \frac{\mu_4}{\sigma^4}) = $$
5% mean
- (10, 10, 0.314, 3.097) ⇐ beta-binomial(200, 189, 3591)
- (10, 10, 0.316, 3.1) ⇐ poisson (10)
25% mean
- (50, 50, 0.1178, 3.001) ⇐ beta-binomial(200, 149, 447)
- (50, 50, 0.1414, 3.02) ⇐ poisson (50)
50% mean
- (100, 100, 0, 2.967) ⇐ beta-binomial(200, 99, 99)
- (100, 100, 0.1, 3.01) ⇐ poisson (100)
75% mean
- (150.01, 149.99, -0.2822, 3.027) ⇐ beta-binomial(200, 49, 16.33)
- (150, 150, 0.0816, 3.007) ⇐ poisson (150)
95% mean
- (190, 190.01, -2.33, 10.008) ⇐ beta-binomial(200, 9, 0.4737)
- (190, 190, 0.0725, 3.005) ⇐ poisson (190)
The last question and often most important I feel, is whether the distribution is a good fit for the underlying process of what is being simulated. To envision a process that matches, I look at how the beta distributions (that correspond to these beta-binomial distributions) have PDFs with a single peak at (about?) $\frac{\mu}{n}$ and that the peak gets sharper and taller as $\mu$ gets smaller.
So the underlying process for this distribution is very similar to the binomial process,
except instead of weighted coins being flipped:
- {0,1} outcome
- weighted $\frac{\mu}{n}$ in favor of 1
it's like darts being thrown:
- at range (0,1)
- bulls-eye at $\frac{\mu}{n}$
- player's precision decreases (~exponentially?) as $\mu$ increases.
AND THEN flipping a weighted coin for each dart:
- {0,1} outcome
- weighted in favor 1 according to where the corresponding dart hit
I made a pretty plot in Mathematica to visualize the clustering of darts. Slices from front to back show the PMF as $\mu \in \{10,20,\ldots,190\}$.