This post is the zero-inflated Poisson instalment in the Worksheet Layout series of Lessons. Shown below in Figures 8.1 and 8.2 are screen shots of the top and bottom portions of my zero-inflated Poisson distribution worksheet (i.e. the ZIP tab) within my working Premier League prediction model. Similar to
Read more →In this lesson, we’ll review screen shots of thePoisson worksheet from my working Premier League prediction model. Shown in Figures 7.1 and 7.2 below, thePoisson worksheet has been constructed using the formulas and techniques described in Chapter 3 of the Practical Sports Prediction Series ebooks.
Read more →In this and subsequent lessons, I will be posting screenshots of my working 2015/2016 Premier League football prediction model. The model is based entirely upon the probability distribution models taught in the Practical Sports Prediction Series ebooks. In a couple of instances, I have optimized the model to include distribution model selection
Read more →In this lesson, you will learn how to use Microsoft Excel’s built-in Visual Basic for Applications (VBA) tool to create a macro for calculating the probability parameter, k, in the negative binomial distribution.
Read more →In this lesson, you will learn how to use Microsoft Excel’s built-in Visual Basic for Applications (VBA) tool to create a macro for calculating the probability parameters in the zero-inflated Poisson distribution model.
Read more →