Forum Discussion
Need help to create a probability for the below table in excel
- You’re working with a Producer at Neo Sports Network, and he has asked you about the chances of Mumbai City FC beating Chennaiyin FC at Mumbai’s home venue, the Mumbai Football Arena. If you were to derive a probability or percentage of Mumbai City FC beating Chennaiyin FC using the below data, how will you model the data?
Mumbai City FC | Wins | Draws | Losses | Goals Scored | Goals Conceded |
Head-to-Head vs Chennaiyin FC | 3 | 2 | 2 | 7 | 2 |
Results in Last 5 Games | 2 | 2 | 1 | 5 | 3 |
Results in Last 5 Home Games | 4 | 1 | 0 | 10 | 2 |
Chennaiyin FC | Wins | Draws | Losses | Goals Scored | Goals Conceded |
Head-to-Head vs Mumbai City FC | 2 | 2 | 3 | 2 | 7 |
Results in Last 5 Games | 1 | 3 | 1 | 2 | 2 |
Results in Last 5 Away Games | 1 | 1 | 3 | 1 | 3 |
1 Reply
This has the earmarks of a homework assignment for a class. Assuming that to be the case, you'll have to show at least some of your own work. Most of us here on this site have agreed we're not here to do homework for students, especially not "from scratch."
So what have you tried so far? What functions have you used? What formulas have you created? Where have you run into a stumbling block?
