5.2 41. Average-Averageif- Lecture - Solved.xlsx.xlsx

	B	C	D	E	F
1	Average and Averageif
2
3	Team	Country	Champions league	Games played	Points earned
4	Borussia	Germany	Yes	34	71
5	Milan	Italy	Yes	38	57
6	Manchester United	England	Yes	38	64
7	Hamburger	Germany	No	34	n.a.
8	Lazio	Italy	No	38	56
9	Fiorentina	Italy	No	38	65
10	Bayern	Germany	Yes	34	90
11	Liverpool	England	No	38	84
12	Arsenal	England	Yes	38	79
13
14
15					72.2
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100