Written by Combines ranges vertically and sequentially to create a larger array.
Analyzes incomplete data pertaining to a linear trend, applies the least squares method to determine an optimal linear fit, and forecasts additional values accordingly.
Switches the arrangement of rows and columns in a specified array or cell range.
Converts a set of data or cells into a single horizontal row.
Converts a range of cells or an array into a single-column format.
Determines the total of squared differences from two sets of values.
Computes the sum of the squared values from two specified arrays.
Determines the total of the squared differences between corresponding elements from two arrays.
Determines the total of the products derived from corresponding elements in two arrays or ranges of the same size.
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.