Maths Formula
 or 
Post a project like this£50(approx. $65)
 Posted:
 Proposals: 12
 Remote
 #675074
 Expired
79881084050214053886094486462720827086603048649523416416590794700857505
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
I need a mathematical formula for excel.
What I'm trying to do is work out the probability of a penalty occurring in a given premiership football match. I have the facts but basically not the knowledge. Basically I want the chance of each team and then to be able to combine them among other factors to find the probability of a penalty occurring during the match.
The data that will processing in the formula is as follows:
1. Average number of penalties awarded each team.
2. Home/ Away advantage
3. Average number of penalties against, Applying that to the opposing teams percentage chance.
4. A factor denoting whether or not a referee is likely to award over or under the average number of penalties for each referee.
5. A factor denoting whether or not a particular match week provides more or less goals than the average.
In the end I want to combine team A v Team B throwing in the referee factor and the matchweek factor. Ultimately to provide a % chance and finally implied odds.
What I'm trying to do is work out the probability of a penalty occurring in a given premiership football match. I have the facts but basically not the knowledge. Basically I want the chance of each team and then to be able to combine them among other factors to find the probability of a penalty occurring during the match.
The data that will processing in the formula is as follows:
1. Average number of penalties awarded each team.
2. Home/ Away advantage
3. Average number of penalties against, Applying that to the opposing teams percentage chance.
4. A factor denoting whether or not a referee is likely to award over or under the average number of penalties for each referee.
5. A factor denoting whether or not a particular match week provides more or less goals than the average.
In the end I want to combine team A v Team B throwing in the referee factor and the matchweek factor. Ultimately to provide a % chance and finally implied odds.
Gary P.
0% (0)Projects Completed

Freelancers worked with

Projects awarded
0%
Last project
20 Oct 2018
United Kingdom
New Proposal
Create an account now and send a proposal now to get this project.
Sign upClarification Board Ask a Question

There are no clarification messages.