beautypg.com

Operator’s manual – Teledyne LeCroy WaveExpert 100H Operators Manual User Manual

Page 266

background image

Operator’s Manual

264

WE-OM-E Rev A

Correlation Excel Waveform Function (Excel Example 3)

This example uses an Excel waveform function to examine the cross-correlation between two
signals, which are both noisy sinusoidal segments. The correlation trace is, of necessity, shorter
than the input traces.

The noise was generated using pseudo-random numbers. Randomize Timer was included in the
VBScript to ensure that the two traces differed, and that subsequent acquisitions differed.
Functions F1 and F2 are included only to simulate signals, and are not part of the measurement
process, which is performed by F3.

This example used the CORREL (Array1, Array2) function of Excel, as depicted below: