Rating football teams/calculating superiority of football teams

Hello everyone. I am trying to rate football teams using data that I have in my workbook. I have already compiled the following:

Total matches played, matches won, drawn and lost, goals scored and goals conceded, goal differences, points for each team, shots on goal, shot accuracy, Clearances, Interceptions, Passes, Pass Accuracy, Total Crosses and Successful Crosses.

Before I upload my file, I would like to know if it is possible to rate football teams using these data. Is it possible to use these data to calculate superiority of football teams?

Anything is possible: it is (probably) a question of applying a value ("weighting") to each of the criteria with an algorithm for applying such values.

In the end probably of very little value unless you can show statistically that there is a correlation with "superiority": what is measure of the latter ... final position in the league table.

Would (taking last season) Leicester have a greater superiority than (for example) Chelsea ?????


I am sure the forum mathematicians can give you a better answer !

Can you help me in achieving this John? Let me know what data and info I need to provide please.

List your criteria in order of contribution to being "Superior":

For example

If you think "Games Won" is most important contributor to your ranking, put this at top the list. You then might consider "Total Goals conceded" as the next i.e. low being good.

Then add a "weighting" to each so "Games Won" is 10% of your superiority so give it this weighting.

Look here ....

http://www.statisticshowto.com/weighting-factor/

I am attaching a workbook named "Rating". I have listed some criteria and added random weights to these criteria. The sum of these criteria is in cell C27. There is a table to the right with values for each team.

Required:

I would like to have a way of awarding each team a numeric rating on a scale of 0 - 1.500 to denote its superiority. The rating should not exceed the value in cell C27. The ratings should be computed for when the team is playing at home, away and overall.

Notes: The following should be taken as a positive:

Fewer matches lost, fewer goals conceded, small average Goals conceded and average Losses per match.


The opposite of the above should be taken to mean a negative.

I will be glad to provide any additional data if needed.

Attachment 512007

Change the weightings to reflect these parameters: perhaps make them negative values?.

Hi, fantastic work on this.iwas just wondering how you have managed to get thoose numbers for i.e. Wins, goals, draws etc,?

Best regards, Jack