50.1K

Verified Solution

Link Copied!

Master League Tables
Club Name	Club Abbreviation	EPL 2021 Position	Games Played	Wins	Draws	Losses	Goals For	Goals Againts	Goals Difference	Points	Yellow Card	Red Card	Discipline Points
2021
Real Madrid	RMA	1	38	26	8	4	80	31	49	86	76	0	76
Barcelona	BAR	2	38	21	10	7	68	38	30	73	94	5	109
Atletico Madrid	ATM	3	38	21	8	9	65	43	22	71	118	7	139
Sevilla	SEV	4	38	18	16	4	53	30	23	70	94	4	106
Real Betis	BET	5	38	19	8	11	62	40	22	65	86	6	104
Real Sociedad	RSO	6	38	17	11	10	40	37	3	62	77	4	89
Villarreal	VIL	7	38	16	11	11	63	37	26	59	76	1	79
Athletic Club	ATH	8	38	14	13	11	43	36	7	55	87	4	99
Valencia	VAL	9	38	11	15	12	48	53	-5	48	118	8	142
Osasuna	OSA	10	38	12	11	15	37	51	-14	47	84	2	90
Celta Vigo	CEL	11	38	12	10	16	43	43	0	46	87	3	96
Rayo Vallecano	RAY	12	38	11	9	18	39	50	-11	42	102	3	111
Elche	ELC	13	38	11	9	18	40	52	-12	42	104	6	122
Espanyol	ESP	14	38	10	12	16	40	53	-13	42	96	7	117
Getafe	GET	15	38	8	15	15	33	41	-8	39	121	8	145
Mallorca	MLL	16	38	10	9	19	36	63	-27	39	110	7	131
Cdiz	CAD	17	38	8	15	15	35	51	-16	39	104	3	113
Granada	GRX	18	38	8	14	16	44	61	-17	38	105	4	117
Levante	LEV	19	38	8	11	19	51	76	-25	35	107	6	125
Alavs	SAD	20	38	8	7	23	31	65	-34	31	94	4	106
2020
Atletico Madrid	ATM	1	38	26	8	4	67	25	42	86	101	0	101
Real Madrid	RMA	2	38	25	9	4	67	28	39	84	58	2	64
Barcelona	BAR	3	38	24	7	7	85	38	47	79	68	2	74
Sevilla	SEV	4	38	24	5	9	53	33	20	77	76	2	82
Real Sociedad	RSO	5	38	17	11	10	59	38	21	62	80	1	83
Real Betis	BET	6	38	17	10	11	50	50	0	61	88	8	112
Villarreal	VIL	7	38	15	13	10	60	44	16	58	65	4	77
Celta Vigo	CEL	8	38	14	11	13	55	57	-2	53	102	5	117
Granada	GRX	9	38	13	7	18	47	65	-18	46	97	6	115
Athletic Club	ATH	10	38	11	13	14	46	42	4	46	79	3	88
Osasuna	OSA	11	38	11	11	16	37	48	-11	44	74	4	86
Cdiz	CAD	12	38	11	11	16	36	58	-22	44	77	3	86
Valencia	VAL	13	38	10	13	15	50	53	-3	43	75	5	90
Levante	LEV	14	38	9	14	15	46	57	-11	41	70	1	73
Getafe	GET	15	38	9	11	18	28	43	-15	38	119	7	140
Alavs	SAD	16	38	9	11	18	36	57	-21	38	87	8	111
Elche	ELC	17	38	8	12	18	34	55	-21	36	96	3	105
Huesca	SDH	18	38	7	13	18	34	53	-19	34	68	2	74
Real Valladolid	RVC	19	38	5	16	17	34	57	-23	31	99	4	111
Eibar	EBA	20	38	6	12	20	29	52	-23	30	67	3	76
2019
Real Madrid	RMA	1	38	26	9	3	70	25	45	87	75	4	87
Barcelona	BAR	2	38	25	7	6	86	38	48	82	89	6	107
Atletico Madrid	ATM	3	38	18	16	4	51	27	24	70	89	3	98
Sevilla	SEV	4	38	19	13	6	54	34	20	70	95	1	98
Villarreal	VIL	5	38	18	6	14	63	49	14	60	78	1	81
Real Sociedad	RSO	6	38	16	8	14	56	48	8	56	74	2	80
Granada	GRX	7	38	16	8	14	52	45	7	56	107	1	110
Getafe	GET	8	38	14	12	12	43	37	6	54	130	7	151
Valencia	VAL	9	38	14	11	13	46	53	-7	53	75	8	99
Osasuna	OSA	10	38	13	13	12	46	54	-8	52	106	6	124
Athletic Club	ATH	11	38	13	12	13	41	38	3	51	90	2	96
Levante	LEV	12	38	14	7	17	47	53	-6	49	68	5	83
Real Valladolid	RVC	13	38	9	15	14	32	43	-11	42	84	0	84
Eibar	EBA	14	38	11	9	18	39	56	-17	42	88	3	97
Real Betis	BET	15	38	10	11	17	48	60	-12	41	104	9	131
Alavs	SDA	16	38	10	9	19	34	59	-25	39	105	7	126
Celta Vigo	CEL	17	38	7	16	15	37	49	-12	37	99	6	117
Legans	CDL	18	38	8	12	18	30	51	-21	36	120	4	132
Mallorca	MLL	19	38	9	6	23	40	65	-25	33	85	5	100
Espanyol	ESP	20	38	5	10	23	27	58	-31	25	98	9	125

1. Create a Master League Table for 3 years, use the combined league points and discipline points for the La Liga clubs to create trends for the Top 5 clubs for 2019, 2020 and 2021.
   1. Hint 1. If a certain club did not qualify for the La Liga in a Year, please keep the corresponding cells vacant for that year
   2. Hint 2. Use the three tables above to create the Master table with 3 year total

Please show me complete table and the steps and required formula to do it.

Answer & Explanation Solved by verified expert

See Answer