Create a formula that compares your calculated probability against the bookmaker's odds.
You repeat this for the away team. The result is a predicted scoreline (e.g., 1.8 vs 1.2). From there, you use a formula ( =POISSON.DIST ) to calculate the exact percentage chance of 0-0, 1-0, 1-1, etc. excel iddaa programi yapma
=1 - POISSON.DIST(Home_Goals_Threshold, Expected_Home_Goals, TRUE) Create a formula that compares your calculated probability