2. Exclude Option

2. Exclude Option

The x-y data is modified from the classic by Milo Gibaldi and Donald Perrier:

The Plot: [1] To exclude one x-y data pair. [2] To exclude using Exclude’s? array argument.

The exclusion is accomplished by the present of the flag value(s) in the Exclude’s? array. For more information see Exclude and Match in the user guide. In this example, the second last x-y data pair is excluded. The post-computation ‘For Your Information . . .’ dialog confirms one x-y data pair is indeed excluded by the exclude option:

Note that the flag value(s) can be a number or text. A text value can have multiple characters. And a number is treated as text. A flag can have more than one value. In this example, the only populated flag has two values, a and b.

Of course the x value and/or the y value could be ‘commented’ out, making the x-y data pair non-numeric, and letting the function auto-excludes. With the xlCurves users have a choice.

To get more from ‘For Your Information . . .’ see Information Messages in the user guide.

Note: Function STD.AUC.LT returns the area under the curve by linear trapezoidal approximation.


M. Gibaldi and D. Perrier. Pharmacokinetics, Second Edition, Revised and Expanded. New York and Basel: Marcel Dekker, Inc. Page 448 (1982).