Descriptive Statistic & Basic Maths functions

FUNCS

About

Array of functions.

Allows for creation of an array of functions which can be passed as a parameter to another function.

e.g. = TRANSFORM(vector, FUNCS(SQRT, LN, LOG_10))

Code

M.S. Excel
FUNCS = LAMBDA(fn_1, [fn_2], [fn_3], [fn_4], [fn_5], [fn_6], [fn_7], [fn_8], [fn_9], [fn_10],
    LET(
        //An array indicating which functions are omitted
        omitted_fns, VSTACK(
            ISOMITTED(fn_1),
            ISOMITTED(fn_2),
            ISOMITTED(fn_3),
            ISOMITTED(fn_4),
            ISOMITTED(fn_5),
            ISOMITTED(fn_6),
            ISOMITTED(fn_7),
            ISOMITTED(fn_8),
            ISOMITTED(fn_9),
            ISOMITTED(fn_10)
        ),
        //count of the not omitted functions
        fn_ct, SUM(--NOT(omitted_fns)),
        //return the first fn_ct functions in an array
        fns, CHOOSE(SEQUENCE(fn_ct), fn_1, fn_2, fn_3, fn_4, fn_5, fn_6, fn_7, fn_8, fn_9, fn_10),
        fns
    )
);