In the Worksheet Layout Lessons thus far, the screen shots shown have corresponded to specific chapters within thePractical Sports Prediction Series ebooks. In this Lesson, I’ll be sharing screen shots of an entirely new worksheet that is not described in the ebooks. The new worksheet is labelled “NBD
Read more →This is the final Worksheet Layout lesson relating to the six probability distribution models taught in the Practical Sports Prediction Series ebooks. The remaining Worksheet Layout lessons will focus upon automating the model selection process and incorporating attacking/defending adjustments to our prediction results. In Figure 12.1 below is
Read more →We’re nearing the end of the “Worksheet Layout” lessons for the distribution models. In Figure 11.1, I have provided a screen shot of the upper portion of the geometric distribution model described in Chapter 7 of the Practical Sports Prediction Series ebooks. Similarly, Figure 11.2 is a
Read more →In this Lesson, I’ll be sharing screen shots of the negative binomial distribution model described in Chapter 6 of thePractical Sports Prediction Series ebooks. Be sure to reviewLesson 5 (Adding Macros to Your NBD Worksheet) to learn how to automate the calculation of the probability parameters in this
Read more →In this Lesson, I’ll be focusing upon the layout of the negative binomial distribution models described in Chapter 5 of thePractical Sports Prediction Series ebooks. The two distribution models taught in Chapter 5 are set out in the “NEG BIN I” worksheet of my spreadsheet model. Since these negative
Read more →