Written by 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.
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.