Table Functions
These functions work with general multi-dimensional tables that contain sub-tables within the primary table. They also support tables with or without keys and with any type of values. Their names have an extra "n" appended to signify that they support table with higher dimensions. Most are generalizations of the Array Functions that support only 1-dimensional arrays. However, none of these functions support class objects or lists of numbers. Most functions perform some type of mathematical processing by selecting only the numeric values in the table.
Several of the table functions return the processed table which can become the input of another function. For example, the following table equation is possible: x = meann( muln( addn( tbl, 20.5), 0.42 ) )). This adds 20.5 to all numeric value in table tbl, then multiples that by 0.42, then calculates the mean value x.
|
Adds a number to the numeric values in a general table. |
|
|
Divides a number into the numeric values in a general table. |
|
|
Flattens the numeric values of a general table into a 1-dimensional array |
|
|
Flattens all values of a general table into a 1-dimensional array |
|
|
Calculates the harmonic mean of the numeric values in a general table. |
|
|
Calculates the harmonic mean and standard deviation of the numeric values in a general table. |
|
|
Returns true of the specified table has more than one dimension (i.e., contains at least on sub-table). |
|
|
Lists the contents of a table. |
|
|
Returns the maximum value in a general table. |
|
|
Returns the mean for the numeric values in a general table |
|
|
Returns the mean and standard deviation for the numeric values in a general table |
|
|
Returns the median for the numeric values in a general table. |
|
|
Returns the median and standard deviation for the numeric values in a general table. |
|
|
Returns the minimum value of the numeric values in a general table. |
|
|
Multiples the numeric values in a general table by a specified number. |
|
|
Normalizes the numeric values in a general table so their sum is 1.0. |
|
|
Returns the specified rank value for numeric values in a general table. |
|
|
Returns the standard deviation of numeric values in a general table. |
|
|
Returns the standard deviation about a specified value for a general table. |
|
|
Subtracts a number from the numeric values of a general table. |
|
|
Returns the sum of numeric values in a general table. |
|
|
Returns the count of numeric elements in a general table. |
|
|
Divided each member of a general table into a specified number. This is often called "reverse division." |
Contents, Table and Array Functions, Array Functions
Mira Pro x64 Script User's Guide, Copyright Ⓒ 2023 Mirametrics,
Inc. All Rights Reserved.