Written by Scans through an array to generate intermediate values by applying a LAMBDA function to each entry. It yields an array containing the intermediate values produced at every individual step.
Reduces an array to an accumulated value by applying a LAMBDA function to each element sequentially.
Calculates the product of two matrices defined as arrays or ranges.
Calculates the multiplicative inverse of a specified square matrix, provided as an array or range.
Calculates the determinant of a square matrix provided as either an array or a range of cells.
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.