Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Anne Britton, Christopher Waterston

3rd Edition

027365859X, 978-0273658597

More Books

Students also viewed these Accounting questions

Question

What is a polytomous variable?

Answered: 1 week ago