Multiple Two Sample T Tests To Compare Rugby Teams?

[apple405]

Hi there Newbie here!

I have a theoretical example I am looking for help on, regarding matches between rugby teams. I believe this may possibly be able to be solved with "multiple two sample T tests?"
I have 10 rugby teams who have played each other (mostly) and I have the score difference between them in each match. And I would like the score difference to be used to determine who is the best team. eg Team A beats Team B 100-0, Team B beats Team C 12-8, but Team C beats Team A 10-0, in this case Team A would be ranked first due to their massive score difference. However, in this scenario not every team has played each other so I will be trying to work of relative frequencies if you get me? [For the image below, the team on the y axis is the first team, meaning if there score is 8, it means they won by 8 points).

 

[CA_Punit]

Team A beats Team B 100-0, Team B beats Team C 12-8, but Team C beats Team A 10-0

how do we know Team A beats team B 100-0

 

[Nishant94]

With data being like this:

	Team A	Team B	Team C	Team D	Team E	Team F	Team G	Team H	Team I	Team J
Team A		-2	-64		21	-18		25
Team B	2		-5	7	-7	-38		-5	-7
Team C	64	5		-2		19		23
Team D		-7	2			18	-25	31	-12
Team E	-21	7				4	14	4
Team F	18	38	-19	-18	-4		11	-40	-17
Team G				25	-14	-11		-11
Team H	-25	5	-23	-31	-4	40	11		-27
Team I		7		12		17		27		-12
Team J									12

Are you looking for something like this:

Book1
	A	B	C
13	Rank	Team	Goal Difference
14	1	Team C	109
15	2	Team I	51
16	3	Team J	12
17	4	Team E	8
18	5	Team D	7
19	6	Team G	-11
20	7	Team F	-31
21	8	Team A	-38
22	9	Team B	-53
23	10	Team H	-54
Sheet6

Cell Formulas
Range	Formula
B14:B23	B14	=INDEX($A$2:$A$11,MATCH(C14,MMULT($B$2:$K$11+0,TRANSPOSE(($B$2:$K$2+1)^0)),0))
C14:C23	C14	=LARGE(MMULT($B$2:$K$11+0,TRANSPOSE(($B$2:$K$2+1)^0)),A14)

 

[apple405]

how do we know Team A beats team B 100-0

Apologies for my confusing approach to the question. I have simplified it below!

 

[apple405]

With data being like this:

	Team A	Team B	Team C	Team D	Team E	Team F	Team G	Team H	Team I	Team J
Team A		-2	-64		21	-18		25
Team B	2		-5	7	-7	-38		-5	-7
Team C	64	5		-2		19		23
Team D		-7	2			18	-25	31	-12
Team E	-21	7				4	14	4
Team F	18	38	-19	-18	-4		11	-40	-17
Team G				25	-14	-11		-11
Team H	-25	5	-23	-31	-4	40	11		-27
Team I		7		12		17		27		-12
Team J									12

Are you looking for something like this:

Book1
	A	B	C
13	Rank	Team	Goal Difference
14	1	Team C	109
15	2	Team I	51
16	3	Team J	12
17	4	Team E	8
18	5	Team D	7
19	6	Team G	-11
20	7	Team F	-31
21	8	Team A	-38
22	9	Team B	-53
23	10	Team H	-54
Sheet6

Cell Formulas
Range	Formula
B14:B23	B14	=INDEX($A$2:$A$11,MATCH(C14,MMULT($B$2:$K$11+0,TRANSPOSE(($B$2:$K$2+1)^0)),0))
C14:C23	C14	=LARGE(MMULT($B$2:$K$11+0,TRANSPOSE(($B$2:$K$2+1)^0)),A14)

Thanks very much for your reply! My question is a bit more complicated than that. As in I would like the points difference between the teams to show how much better one team is than another and then average it out. I have simplified the data below.

In this example, the results are as follows:
Team A 0-0 Team B (no points difference)
Team A 50-0 Team C (+50 points difference)
Team B 60-0 Team C (+60 points difference)
Team C 0-12 Team D (-12 points differnence)
So we can deduce; Team A is equal to Team B, Team A is 50 points better than Team C, Team B is 60 points better than Team C (which now means Team B is 10 points better than Team A if you get me, but as I said before they are also equal, so I am going to average the difference )[10+0]/2 and say that Team B is 5 points better than Team A. It's really about comparing the 4 teams with relative values/proportions? If you have a better suggestion about how I could compare the data to see how the teams rank I would be very grateful!

 

[apple405]

 

[CA_Punit]

I have drawn a sheet where we can find that which Team is better than Which team. Please go through this and let me know whether i am correct with my concept

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
2		Team A	Team B	Team C	Team D	Team E	Team F	Team G	Team H	Team I	Team J		Team A	Team B	Team C	Team D	Team E	Team F	Team G	Team H	Team I	Team J
3	Team A		-2	-64		21	-18		25			Team A	0	0	0	0	21	0	0	25	0	0
4	Team B	2		-5	7	-7	-38		-5	-7		Team B	2	0	0	7	0	0	0	0	0	0
5	Team C	64	5		-2		19		23			Team C	64	5	0	0	0	19	0	23	0	0
6	Team D		-7	2			18	-25	31	-12		Team D	0	0	2	0	0	18	0	31	0	0
7	Team E	-21	7				4	14	4			Team E	0	7	0	0	0	4	14	4	0	0
8	Team F	18	38	-19	-18	-4		11	-40	-17		Team F	18	38	0	0	0	0	11	0	0	0
9	Team G				25	-14	-11		-11			Team G	0	0	0	25	0	0	0	0	0	0
10	Team H	-25	5	-23	-31	-4	40	11		-27		Team H	0	5	0	0	0	40	11	0	0	0
11	Team I		7		12		17		27		-12	Team I	0	7	0	12	0	17	0	27	0	0
12	Team J									12		Team J	0	0	0	0	0	0	0	0	12	0
13
14											Team 1	Team 2
15							1				Team A	Team B	0
16							2				Team A	Team C	0
17							3				Team A	Team D	0
18							4				Team A	Team E	21
19							5				Team A	Team F	0
20							6				Team A	Team G	0
21							7				Team A	Team H	25
22							8				Team A	Team I	0
23							9				Team A	Team J	0
24							1				Team B	Team A	2
25							2				Team B	Team C	0
26							3				Team B	Team D	7
27							4				Team B	Team E	0
28							5				Team B	Team F	0
29							6				Team B	Team G	0
30											Team B	Team H	0
31											Team B	Team I	0
32											Team B	Team J	0
33											Team C	Team A	64
34											Team C	Team B	5
35											Team C	Team D	0
36											Team C	Team E	0
37											Team C	Team F	19
38											Team C	Team G	0
39											Team C	Team H	23
40											Team C	Team I	0
41											Team C	Team J	0
42											Team D	Team A	0
43											Team D	Team B	0
44											Team D	Team C	2
45											Team D	Team E	0
46											Team D	Team F	18
47											Team D	Team G	0
48											Team D	Team H	31
49											Team D	Team I	0
50											Team D	Team J	0
51											Team E	Team A	0
52											Team E	Team B	7
53											Team E	Team C	0
54											Team E	Team D	0
55											Team E	Team F	4
56											Team E	Team G	14
57											Team E	Team H	4
58											Team E	Team I	0
59											Team E	Team J	0
60											Team F	Team A	18
61											Team F	Team B	38
62											Team F	Team C	0
63											Team F	Team D	0
64											Team F	Team E	0
65											Team F	Team G	11
66											Team F	Team H	0
67											Team F	Team I	0
68											Team F	Team J	0
69											Team G	Team A	0
70											Team G	Team B	0
71											Team G	Team C	0
72											Team G	Team D	25
73											Team G	Team E	0
74											Team G	Team F	0
75											Team G	Team H	0
76											Team G	Team I	0
77											Team G	Team J	0
78											Team H	Team A	0
79											Team H	Team B	5
80											Team H	Team C	0
81											Team H	Team D	0
82											Team H	Team E	0
83											Team H	Team F	40
84											Team H	Team G	11
85											Team H	Team I	0
86											Team H	Team J	0
87											Team I	Team A	0
88											Team I	Team B	7
89											Team I	Team C	0
90											Team I	Team D	12
91											Team I	Team E	0
92											Team I	Team F	17
93											Team I	Team G	0
94											Team I	Team H	27
95											Team I	Team J	0
96											Team J	Team A	0
97											Team J	Team B	0
98											Team J	Team C	0
99											Team J	Team D	0
100											Team J	Team E	0
101											Team J	Team F	0
102											Team J	Team G	0
103											Team J	Team H	0
104											Team J	Team I	12
105											#REF!	#REF!	#REF!
106											#REF!	#REF!	#REF!
107											#REF!	#REF!	#REF!
108											#REF!	#REF!	#REF!
109											#REF!	#REF!	#REF!
110											#REF!	#REF!	#REF!
111											#REF!	#REF!	#REF!
112											#REF!	#REF!	#REF!
113											#REF!	#REF!	#REF!
114											#REF!
115
116
117
118
Sheet3

Cell Formulas
Range	Formula
M3:V12	M3	=IF(B3:K12<0,0,B3:K12)
K15:K114	K15	=INDEX($L$3:$L$12,INT((ROW(A1:A100)-ROW(A1))/9)+1)
L15:L113	L15	=INDEX($M$2:$V$2,SMALL(IF($M$2:$V$2<>K15,COLUMN($A:$J)),MOD(ROWS($A$1:A1)-1,9)+1))
M15:M113	M15	=INDEX($M$3:$V$12,MATCH(K15,$L$3:$L$12,0),MATCH(L15,$M$2:$V$2,0))
G15:G29	G15	=MOD(ROWS($A$1:A1)-1,9)+1
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.
Dynamic array formulas.

 

[Nishant94]

A logical approach for ranking would be to have a number of wins as the first criteria and then in case of an equal number of wins, goal difference should be considered as a factor after the number of wins.

For Example, in the below table you can see that Team C, E & I are having equal no. of wins. In that case, the Goal difference should be the deciding factor.

	Team A	Team B	Team C	Team D	Team E	Team F	Team G	Team H	Team I	Team J	No. of Wins	Goal Difference	Remaks
Team A		-2	-64		21	-18		25			2	-38
Team B	2		-5	7	-7	-38		-5	-7		2	-53
Team C	64	5		-2		19		23			4	109	Rank 1
Team D		-7	2			18	-25	31	-12		3	7
Team E	-21	7				4	14	4			4	8	Rank 3
Team F	18	38	-19	-18	-4		11	-40	-17		3	-31
Team G				25	-14	-11		-11			1	-11
Team H	-25	5	-23	-31	-4	40	11		-27		3	-54
Team I		7		12		17		27		-12	4	51	Rank 2
Team J									12		1	12

Note: The columns "No. of Wins", "Goal Difference" and "Remarks" are just to make you understand the concept and are not required for the function to work. You can delete them if you want

Book1
	A	B
15	Rank	Team
16	1	Team C
17	2	Team I
18	3	Team E
19	4	Team D
20	5	Team F
21	6	Team H
22	7	Team A
23	8	Team B
24	9	Team J
25	10	Team G
Sheet1

Cell Formulas
Range	Formula
B16:B25	B16	=INDEX($A$2:$A$11,MATCH(LARGE(MMULT(--($B$2:$K$11>0),TRANSPOSE(COLUMN($B$2:$K$2)^0))+(MMULT($B$2:$K$11+0,TRANSPOSE(COLUMN($B$2:$K$2)^0))/SUM(ABS($B$2:$K$11))),A16),MMULT(--($B$2:$K$11>0),TRANSPOSE(COLUMN($B$2:$K$2)^0))+(MMULT($B$2:$K$11+0,TRANSPOSE(COLUMN($B$2:$K$2)^0))/SUM(ABS($B$2:$K$11))),0))