Analog Interfacing to Embedded Microprocessor Systems, 2nd Edition

Table 4.1 was generated using a Microsoft Excel spreadsheet. The spreadsheet was

configured as follows:

.

Column A: 1000 rows containing: Rand( ) (generates 1000 random numbers)

.

Column B: 1000 rows containing: Value þ Ax

.

Column C: 1000 rows containing: TRUNC(Bx, 0)

.

Column D: 1000 rows containing: IF(Cx ¼ 3, 1, 0) (Puts 1 in the cell if Cx ¼ 3, 0 in the

cell if Cx ¼ 4)

To calculate the result for 100 samples, the first 100 values in column C were added

together and the result divided by 100. For 1000 samples, all the values in column C were

added together and divided by 1000.

Note: In all cases, the ‘‘x’’ in the cells corresponds to the row number. For example, cell

C4 contains: TRUNC(B4,0).

‘‘Value’’ in column B was the value of the event being measured: ...