
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)] 