Workbooks

1 Excel workbooks and other tools

Purchase to NBD-Dirichlet
An MS-Excel workbook that takes a dataframe of customer-purchases and derives parameters for the Negative Binomial model and the Dirichlet model in a set of step-by-step worksheets.

Download the Purchase to NBD workbook{download}

k Estimator
An MS-Excel macro workbook for estimating the NBD \(k\) parameter from mean-category-purchases per period, \(\mu\), and Observed proportion of non-buyers per period, \(p(0)\).

Download the Estimate k workbook{download}

Negative Binomial Probability Mass Function calculator
NB_PMF_calculator is an MS-Excel workbook that estimates the probability of specific number of purchases based on the mean-category-purchases per period, (\(\mu\)) and the NBD \(k\) parameter. Optionally, the worksheet estimates revenue from the NBD model.

Download the NB_PMF_calculator workbook{download}