EXAMPLE - LIST Math Functions

This example describes how to generate random array (list) data and then to apply the following math functions to your arrays.

• LISTSUM - Sum all values in the array. See LISTSUM Function.
• LISTMIN - Minimum value of all values in the array. See LISTMIN Function.
• LISTMAX - Maximum value of all values in the array. See LISTMAX Function.
• LISTAVERAGE - Average value of all values in the array. See LISTAVERAGE Function.
• LISTVAR - Variance of all values in the array. See LISTVAR Function.
• LISTSTDEV - Standard deviation of all values in the array. See LISTSTDEV Function.
• LISTMODE - Most common value of all values in the array. See LISTMODE Function.

Source:

For this example, you can generate some randomized data using the following steps. First, you need to seed an array with a range of values using the RANGE function:

Then, unpack this array, so you can add a random factor:

Add the randomizing factor. Here, you are adding randomization around individual values:  x-1 < x < x+4.

To make the numbers easier to manipulate, you can round them to two decimal places:

Renest these columns into an array:

Delete the unused columns:

Your data should look similar to the following:

Transformation:

These steps demonstrate the individual math functions that you can apply to your list data without unnesting it:

Sum of all values in the array (list):

Minimum of all values in the array (list):

Maximum of all values in the array (list):

Average of all values in the array (list):

Variance of all values in the array (list):

Standard deviation of all values in the array (list):

Mode (most common value) of all values in the array (list):

Results:

Results for the first four math functions:

Results for the statistical functions:

Since all values are unique within an individual array, there is no most common value in any of them, which yields empty values for the arrayMode column.