ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Sheet nameDescription
3
Success percentageRandomly generates the success percentages of 7 players in the last 10 games, under the following conditions:
- All the averages are the same.
- Player number 4 shows the highest variability.
- Player number 5 shows the lowest variability.

The combined line graph is shown.

The random nature allows different groups of students to use different data, even if all reach the same conclusions.

WARNING: every time that any part of the spreadsheet is modified, the random data update.
4
Players (all)The "SuccessPercentage" page shows the following for each of the 7 players:
- Basic statistics: data, average, maximum, minimum, range, deviations, absolute deviations, average absolute deviation,
quadratic deviations, variance, and standard deviation.
- Graphs: point diagram showing the average, line diagram.

WARNING: every time that any part of the spreadsheet is modified, the random data update.
5
Copy of SuccessPercentage (blank)
Copy of Players (to check)		- These are copies of the respective spreadsheets "SuccessPercentage" and "Players (all)" that are blank (no data entered) and not linked to the random data generation.
- By manually entering the data on the 7 players onto the sheet "Copy of SuccessPercentage (blank)," the calculations and
graphs from the sheet "Copy of Players (to check)" automatically generate.
- Both sheets are to check the solution provided by students.
6
Cultivos Navarra
7
8
9
10
11
12
13
14
15
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