Using Poisson Distribution to predict football matches

We demonstrate how you can export football results from the fixtures & results page of the website (https://www.football-bet-data.com/his...) and export into Excel. The vide shows games from English League 1 in this example from the 2020/21 season.

With the data in place we cover functions in Excel such as POISSON.DIST, VLOOKUP, HLOOKUP, SUMIF, LEFT, RIGHT, SUM as well as conditional formatting to highlight potential value bets for the football matches shown, and how to use a Pivot Table to display all the teams in the league.

The video shows from start to finish the process required to use Poisson Distribution to identify potential value bets in football games.

You may need to watch a few times, all formula required and explanations are shown within the video.

We hope you find it of use