Transcription of bgnbd spreadsheet note - Bruce Hardie
{{id}} {{{paragraph}}}
Implementing the BG/NBD Model forCustomer Base Analysis in IntroductionThis note describes how to implement the BG/NBD model for customerbase analysis1using Microsoft Excel. There are three key stages to theimplementation of this model:1. estimating the model parameters,2. generating the aggregate sales forecast given these parameter esti-mates, and3. predicting a particular customer s future purchasing, given informationabout his past behavior and the parameter specific steps are outlined in sections 3 5 below. Section 2 briefly de-scribes the nature of the data used for model calibration.
ImplementingtheBG/NBDModelfor CustomerBaseAnalysisinExcel Peter S. Fader www.petefader.com Bruce G.S. Hardie www.brucehardie.com Ka Lok Lee† www.kaloklee.com
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}