Scribd
Upload
203 views6 pages

Excel Module 4

The document contains statistics tracking the goals scored by 10 Premier League players over 9 rounds of games. It shows the goals each player scored in each round. It then calculates the total goals scored each round, the average goals per round, and the total and maximum goals scored over the season. Bar charts are included to visualize the top goal scorers.

Uploaded by

api-352924653
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
203 views6 pages

Excel Module 4

The document contains statistics tracking the goals scored by 10 Premier League players over 9 rounds of games. It shows the goals each player scored in each round. It then calculates the total goals scored each round, the average goals per round, and the total and maximum goals scored over the season. Bar charts are included to visualize the top goal scorers.

Uploaded by

api-352924653
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

Juan Rojas Feb.

7th, 2017
EDT 180C:
Excel Application Barclay's Premier
Assignment Spring
2017

Round 1 Round 2 Round 3 Round 4 Round 5 Round 6 Round 7 Round 8 Round 9


Delle Alli 0 1 2 1 0 1 1 2 1
Alexis Sanchez 3 1 0 0 0 0 2 3 0
Harry Kane 1 1 0 1 0 1 3 0 0
Zlatan Ibrahimovic 1 1 3 0 1 2 1 2 0
Diego Costa 0 0 1 2 1 0 0 0 0
Jamie Vardy 0 1 0 0 0 0 0 0 0
Paul Pogba 1 0 0 0 0 0 0 2 0
Sergio Aguero 1 0 0 0 0 2 1 1 1
Romelu Lukaku 2 3 1 0 0 0 0 0 0
Eden Hazard 1 2 0 0 0 0 4 2 1

Total Goals/Round 10 10 7 4 2 6 12 12 3

Average Goals/Round 1.0 1.0 0.7 0.4 0.2 0.6 1.2 1.2 0.3

Total Goals Scored in


the Season 148
Maximum Goals Scored
in the Season 4
Minimum Goals Scored
in the Season 0

Barclay's Top Goal


14

12
Barclay's Top Goal
14

12

10

Delle Alli Alexis Sanchez Harry Kane


Jamie Vardy Paul Pogba Sergio Aguero
Premier League Top Goal Scorers

Round 10 Round 11 Round 12 Round 13 Round 14 Round 15 Round 16 Round 17 Round 18 Round 19 Round 20
0 0 0 1 0 0 0 2 0 0 0
2 1 1 1 0 0 1 2 1 1 0
0 2 1 0 0 2 1 1 0 0 0
2 1 0 0 3 0 1 0 0 1 2
3 0 2 1 2 4 0 1 1 0 2
3 0 0 0 0 0 0 0 0 2 1
0 0 0 0 0 3 1 0 0 0 2
1 0 1 0 0 0 1 1 0 1 0
1 2 0 0 0 0 0 0 0 1 2
1 3 0 2 0 1 0 1 1 3 1

13 9 5 5 5 10 5 8 3 9 10

1.3 0.9 0.5 0.5 0.5 1.0 0.5 0.8 0.3 0.9 1.0

Barclay's Top Goal Scorers


Barclay's Top Goal Scorers

anchez Harry Kane Zlatan Ibrahimovic Diego Costa


gba Sergio Aguero Romelu Lukaku Eden Hazard
Total Average
Goals by Goals by
Player Player
12 0.60 Hat Trick 3 + goals
19 0.95
14 0.70
21 1.05
20 1.00
7 0.35
9 0.45
11 0.55
12 0.60
23 1.15

You might also like