In trying to develop a model in excel to predict football outcomes (1X2,Over/Under,Both Teams to Score/Both Teams not to score), I realized that the probability of draws and the probability of zero is underestimated when using Poisson Distribution. But after doing some search online, I kept coming across suggestions that using the zero-inflated Poisson can improve the accuracy of the results.
Question:
Is it possible to create a zero-inflated Poisson in Excel? I will appreciate all the help I can get.
Attached is my workbook:
Poisson.xlsxPoisson.xlsx
Note: Data in workbook obtained from below website:
https://www.sbo.net/strategy/footbal...-distribution/
Bookmarks