Written by Associates each value from the input arrays with a new value by applying a LAMBDA function to every single value.
Generates an array of defined dimensions filled with values determined through a LAMBDA function.
Calculates key parameters for an ideal exponential growth curve based on incomplete data.
Utilizing partial data concerning a linear trend, determines various characteristics of the optimal linear trend through the least-squares method.
Concatenates specified ranges side by side, producing a larger array as a result.
Consolidates all values from one or multiple ranges into a singular column.
Generates a new array based on selected rows from an existing range.
Generates a new array using specific columns from a given range.
Applies a LAMBDA function to each row of an array, effectively grouping by rows.
Groups an array by columns by applying a LAMBDA function to each individual column.