Archive for the Lessons Category

Lesson # 3 – Activating the Developer Tools Within Excel

Many of the spreadsheet models described in the Practical Sports Prediction Series utilize Excel formulas to automatically calculate unknown probability parameters, including lambda (λ) in the Poisson distribution model. 

Read more

Lesson #2 – Automating the Summation of Goal Values

The ebooks in the Practical Sports Prediction Series teach you how to use the Poisson, zero-inflated Poisson, negative binomial, geometric and uniform distribution models to predict the outcomes of football matches. 

Read more

Lesson #1 – Using COUNTIF Functions

If you have purchased one of the Practical Sports Prediction Series ebooks from Amazon, you will have learned how to fit the Poisson, zero-inflated Poisson, negative binomial, geometric, and uniform distribution models to football match data.

Read more