0
I’m wondering the logic of how to calculate the percentage of tables in a football game.
For example, I put a quick Excel tabelinha here just for demonstration. In red is the real percentage, and next is the percentage that I got.
So my question is how to reach 100% when you win all, 77% when you win 2 and draw 1 and when it’s 44% when you win 1, draw 1 and lose 1.
What is the logic used in this calculation? I tried to break my head but at this point, I did not get any results.
5
To calculate the percentage in this case, with 3 elements, you calculate the difference of the item you are looking for in relation to the total sum. Ex:
To know the % of victories:
3 / (3 + 4 + 1)
3 / 8
0,375
37,5% de vitórias
To know the % of defeats:
4 / (3 + 4 + 1)
4 / 8
0,5
50% de derrotas
To know the % of draws:
1 / (3 + 4 + 1) * 100
1 / 8
0,125
12,5% de derrotas
Soon:
37,5% + 50% + 12,5% = 100%
Ah! I understood Diego. I was trying to calculate in this logic that you showed there. But I was doing it wrong. That was my logic, just the execution that was wrong. Thank you.
0
Probably doesn’t matter to the colleague anymore, but I’ll answer in case someone searches:
If you are considering the score of football games currently, that is, 3 points for a win, 1 point for a draw and 0 points for defeats, then we do the following:
We calculated the maximum number of points a team could earn: For example, if she played 8 matches, she can earn a maximum of 24 points =(8*3).
So we have number 24.
Now, suppose that this team in these 8 matches won 5, drew 1 and lost 2. In this case (according to the rules of football) she added 16 points.
Now just divide 16 by 24 and multiply by 100 to get the percentage
=(16/24)*100= 66,66
That is, this team had a 66,66% in the 8 matches that played.
Now an observation, if you want to do this calculation using a general basis, without using the scoring system of football or another sport, you can put a win as being 100%, a 50% draw and a 0% defeat. If we use this system in the example above, for example, we would have =8*100%= 800% (which is the maximum number we could reach), as the team won 5 matches and drew 2, he would have 550%, then just split =550%/800% that would give 68.75%.
Although the result is different, both calculations are correct as they use different bases.
In fact the answer has already been answered. And I already got what I wanted. The colleague Diego already helped me. It was for this question is closed. I don’t know why it’s open yet.
Browser other questions tagged php excel
You are not signed in. Login or sign up in order to post.
You want in PHP or in Excel? You have to decide, if not you keep enlarging the question.
– UzumakiArtanis
Where did these numbers come from? Who said this is the real percentage? Because these percentages of 77 and 44 don’t make sense. The correct would be 66 and 33.
– bfavaretto
If the problem is only of mathematics, it is not in the scope. If it is of programming, click on [Edit] and put only one [mcve] of the problem in the post.
– Bacco
Bacco, colleague. This question has been answered for a long time. This question was supposed to be closed. I don’t know why it’s pending if I’ve already marked the answer.
– Sandson Costa