Master League Tables Club Name Club Abbreviation EPL 2021 Position Games Played Wins Draws...

50.1K

Verified Solution

Question

Accounting

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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students