ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Introduction
3
4
5
6
This workbook is designed to help you build your algorithms. Your algorithm must rate or rank things within a category. But what's the difference between ratings and rankings?

Rating algorithms assign scores to things using user input or data (like a player's points total). When you know the maximum score, a rating can tell you how good something is. For example, if Incluvie gives Black Panther a score of 5 out of 5, then you know it is good for diversity. But, if both Black Panther and Crazy Rich Asians receive a score of 5, you can't tell which movie is better for diversity.

Ranking algorithms give you an ordered list that tells you how one thing compares to another. They can be great for comparing things. Ranking algorithms are not so great for telling you how good something is. For example, a ranking algorithm that compares ice cream flavors might ask users to rank several flavors. The algorithm then combines these rankings to create a final ranking or list. This list can tell you that cotton candy ice cream is better than lobster ice cream. It does not tell you whether cotton candy is a good flavor of ice cream.

Use the next two tabs in the worksheet to:
1. Learn how to build algorithms in spreadsheets,
2. Explore sample algorithms, and
3. Understand how to use weighted categories in your algorithms.
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