Enter four random numbers into column A,B,C & D.
In all other cells below A,B,C & D, insert formula (See handout for formula and copying to cells)
| Column A | Column B | Column C | Column D | |||
| 342 | 78 | 143 | 19 | |||
| 264 | 65 | 124 | 323 | |||
| 199 | 59 | 199 | 59 | |||
| 140 | 140 | 140 | 140 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
| 0 | 0 | 0 | 0 | |||
The 'optimization of zero' for this example occurred in only five rows.