SheetFX
≡
<< Go back to all functions

MINVERSE

The MINVERSE function in Google Sheets returns the multiplicative inverse of a square matrix specified as an array or range. This function is useful when you need to calculate the inverse of a matrix for various mathematical operations.

Function Syntax and Parameters

Syntax: MINVERSE(square_matrix)

Parameters:

  • square_matrix: The square matrix (array or range) for which you want to find the multiplicative inverse.

Step-by-Step Tutorial

  1. Using MINVERSE with a matrix:
    • Example: If A1:C3 contains a 3x3 matrix, then =MINVERSE(A1:C3) will return its inverse.

Use Cases and Scenarios

  1. Linear Algebra: Calculating the inverse of a matrix is frequently used in linear algebra for various computations.
  2. Engineering Analysis: Finding the inverse of a matrix is often required in engineering analysis and simulations.
  3. Statistical Analysis: In statistical analysis, matrix inversion is used for computations related to regression, covariance matrices, and more.

Related Functions

  • MDETERM: Returns the determinant of a square matrix.
  • MMULT: Performs matrix multiplication on two arrays.
  • TRANSPOSE: Transposes the rows and columns of a specified matrix.

Related Articles