Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Array
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Array

Instruction: ARRAY_CONSTRAIN(input_range, num_rows, num_cols)
Returns: Constrains an array result to a specified size. Learn more

Instruction: BYCOL(array_or_range, LAMBDA)
Returns: Groups an array by columns by application of a LAMBDA function to each column. Learn more

Instruction: BYROW(array_or_range, LAMBDA)
Returns: Groups an array by rows by application of a LAMBDA function to each row. Learn more

Instruction: FLATTEN(range1,[range2,...])
Returns: Flattens all the values from one or more ranges into a single column. Learn more

Instruction: FREQUENCY(data, classes)
Returns: Calculates the frequency distribution of a one-column array into specified classes. Learn more

Instruction: GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
Returns: Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. Learn more

Instruction: LINEST(known_data_y, [known_data_x], [calculate_b], [verbose])
Returns: Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. Learn more

Instruction: LOGEST(known_data_y, [known_data_x], [b], [verbose])
Returns: Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. Learn more

Instruction: MAKEARRAY(rows, columns, LAMBDA)
Returns: Returns an array of specified dimensions with values calculated by application of a LAMBDA function. Learn more

Instruction: MAP(array1, [array2, ...], LAMBDA)
Returns: Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. Learn more

Instruction: MDETERM(square_matrix)
Returns: Returns the matrix determinant of a square matrix specified as an array or range. Learn more

Instruction: MINVERSE(square_matrix)
Returns: Returns the multiplicative inverse of a square matrix specified as an array or range. Learn more

Instruction: MMULT(matrix1, matrix2)
Returns: Calculates the matrix product of two matrices specified as arrays or ranges. Learn more

Instruction: REDUCE(initial_value, array_or_range, LAMBDA)
Returns: Reduces an array to an accumulated result by application of a LAMBDA function to each value. Learn more

Instruction: SCAN(initial_value, array_or_range, LAMBDA)
Returns: Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step. Learn more

Instruction: SUMPRODUCT(array1, [array2, ...])
Returns: Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges. Learn more

Instruction: SUMX2MY2(array_x, array_y)
Returns: Calculates the sum of the differences of the squares of values in two arrays. Learn more

Instruction: SUMX2PY2(array_x, array_y)
Returns: Calculates the sum of the sums of the squares of values in two arrays. Learn more

Instruction: SUMXMY2(array_x, array_y)
Returns: Calculates the sum of the squares of differences of values in two arrays. Learn more

Instruction: TRANSPOSE(array_or_range)
Returns: Transposes the rows and columns of an array or range of cells. Learn more

Instruction: TREND(known_data_y, [known_data_x], [new_data_x], [b])
Returns: Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values. Learn more