Signature (Visual Basic / VBA)
Dim adblData(1 To 3) As Double
Dim varData1 As Variant
Dim varData2 As Variant
adblData(1) = 65 : adblData(2) = 43 : adblData(3) = 32
varData1 = Array(56,34, 12)
varData2 = Array(78, 90, Array(23, 45))
Minimum(varData1, varData2, 87, 54, adblData) = 12
Code Examples
Dim avarData(1 To 3) As Variant
avarData(1) = 34 : avarData(2) = 12 : avarData(3) = 56
MinimumArray(avarData) = 12
StatVarType(vbBoolean) = False
Array(12, 34, 56)
Dim avarArray(1 To 3) As Variant
avarArray(1) = 12
avarArray(2) = 34
avarArray(3) = 56
Notes & Version History
| Difference between regular and Array functions | This Class contains two distinct groups of functions that differ in the types of arguments that they will accept. 1. One group of functions has ParamArray type arguments, which means that they will accept any number and combination of arguments. Each of those arguments can be individual numbers, one-dimensional Variant arrays containing numeric values, one-dimensional numeric arrays of some type, or Variant arrays that contain numbers and/or other Variant arrays, as the following example illustrates: See the MathStatistics_Initialize Subroutine and StatVarType Property for more information about which numeric data types are recognized by this group of functions. 2. The functions whose names end with the word "Array" assume that numeric data is passed to the function in the form of an array. The array can be either a one-dimensional Variant array containing numeric values, or it can be a one-dimensional numeric array of some type. For example, the MinimumArray function assumes that its argument is a single array: |
| Data Types Recognized | By default, the functions in this Class will operate on all of the following numeric and logical data types: Boolean, Byte, Currency, Date, Decimal, Double, Integer, Long, and Single. By setting the StatVarType Property, you can restrict many of the functions in this Class so that they only operate on some of these data types. For example, you can set the StatVarType Property so that most of the statistical functions will ignore Boolean values by making the following Property setting: The documentation for each function describes whether or not the function uses the StatVarType Property to determine the types of numeric values to recognize. |
| Function Examples | Many of the examples use the Visual Basic "Array" function, which is a simple way to create a Variant array containing specific values. returns a one-dimensional Variant array containing three elements, and it is equivalent to the following code: |
| v1.5 Addition | This class is new to this version of Entisoft Tools. |