Creating a Fit Histogram for the BG/NBD Model
This note shows how to "code up" in Excel the formula for P(X(t)=x) under the BG/NBD model, and therefore evaluate the fit of the model by comparing the actual frequency distribution of transaction counts with that predicted by the model.
Note [PDF (81k)]
Excel spreadsheet [ZIP (132k)]