# Ranking and probabilities about games and league table

#### elgrousso35

##### New Member
Hello everyone,

I need your help to answer these questions on which I have spent a lot of time but am not making any progress...

1. Construct the current League Table - ordered by points (3 for a win, 1 for a draw), goal difference and then goals scored.
2. Produce prices for the upcoming fixtures, replacing the ?s with probabilities
3. Calculate the probability of each team winning the league, finishing in the top 4 and being relegated (bottom 3). Every team plays everyone else, home and away.
I work with Excel 2019 in English

upcoming_fixtures.xlsx
ABCDEF
1Match IDHome IDAway ID1X2
2161814???
3162713???
41631910???
5164181???
6165174???
7166203???
8167126???
91681511???
1016995???
11170216???
12171118???
13172139???
1417332???
15174410???
16175518???
17176715???
18177166???
191781419???
201791720???
21180112???
upcoming_fixtures(3922)

sample_data.xlsx
ABCDEFG
1Match IDHome IDAway ID1X2Score
215173.283.22.3901:01
326182.353.453.0703:01
431081.226.5416.1602:00
5414113.333.572.201:03
6516153.063.552.3302:02
7619203.853.432.0503:04
87472.963.262.5502:03
981232.693.462.6802:03
109293.863.741.9700:03
11101131.246.4313.3302:00
121111181.653.895.8304:04
13121761.783.694.8802:02
1413816.054.241.5800:03
151415124.213.861.8402:02
1615422.933.432.4801:00
17169161.168.7617.4402:00
181713109.655.091.3600:02
19182051.564.256.3700:00
20193191.275.9912.9204:00
21207141.743.824.9703:01
222112111.853.784.3304:00
23222171.773.94.6401:00
24231151.474.886.5701:03
25241643.243.372.3200:01
26251881.693.795.5800:00
27261998.995.211.3600:02
28271032.083.63.6200:01
2928673.853.711.9802:01
302914202.913.392.5203:01
31305131.853.514.7401:01
323117182.123.253.9302:01
33322061.753.854.8702:01
3433824.614.081.7400:02
35349122.253.463.3503:02
36354191.683.885.4800:01
373613142.983.312.5100:02
38371551.64.375.5702:02
3938713.013.382.4704:03
sample_data

Last edited by a moderator:

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Hello everyone,

I need your help to answer these questions on which I have spent a lot of time but am not making any progress...

1. Construct the current League Table - ordered by points (3 for a win, 1 for a draw), goal difference and then goals scored.
2. Produce prices for the upcoming fixtures, replacing the ?s with probabilities
3. Calculate the probability of each team winning the league, finishing in the top 4 and being relegated (bottom 3). Every team plays everyone else, home and away.
I work with Excel 2019 in English

Replies
10
Views
217
Replies
10
Views
288
Replies
5
Views
2K
Replies
3
Views
791
Replies
1
Views
448

1,203,072
Messages
6,053,377
Members
444,660
Latest member
Mingalsbe

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back