Log 5 Win Probability


This calculator uses the Log 5 Formula to find the win probability given the winning percentages of two teams. Below the table is the Excel User Defined Function to implement the formula into a spreadsheet.

Enter Home Team Win Percentage (As Decimal):
Enter Road Team Win Percentage (As Decimal):
Enter Home Field Advantage (As Decimal):
Home Team Road Team
Win Probability:
US Line:
Decimal: 
Function log5form(TeamA, TeamB)
log5form = (TeamA - TeamA * TeamB) / (TeamA + TeamB - 2 * TeamA * TeamB)
 
End Function
  1. No comments yet.

You must be logged in to post a comment.