How do you represent data as a series of numerical values?

Answer 1

You can assign a numerical value to each element in your data series. There are several ways to do that. Here is a simple example:

1. In cell A1 enter your first data element. Let that entry be GREEN.
2. In cell B1 enter the formula, =IF(A1="GREEN",1,0). Observe that the value of B1 is 1, since the contents of cell A1 is GREEN. If A1 = RED, then B1 would display 0.

You also could give a value to each data item depending on the number of characters in the cell. You can do this with the formula =LEN(A1).