MINVERSE function - The function returns the inverse matrix of a given matrix in Excel

Usually the process of calculating the inverse matrix of a given matrix is very confusing and manual calculations take a lot of time. The following article shows how to use the MINVERSE function in Excel, which returns the inverse matrix of a given matrix.

Description: The function returns the inverse matrix of a given matrix.

Syntax: MINVERSE (array) .

Inside:

- array is an array with equal number of rows and columns.

Example: Find the inverse matrix of the following matrix:

MINVERSE function - The function returns the inverse matrix of a given matrix in Excel Picture 1

Step 1: In the cell to calculate the inverse matrix, enter the formula: MINVERSE (D6: D8) .

MINVERSE function - The function returns the inverse matrix of a given matrix in Excel Picture 2

Step 2: After entering the formula, press Enter to get the results:

MINVERSE function - The function returns the inverse matrix of a given matrix in Excel Picture 3

Step 3: Highlight the data area from D11: F13 (note the number of rows and highlighted columns depending on the original size of the matrix) -> Press F2 to get the results as shown:

MINVERSE function - The function returns the inverse matrix of a given matrix in Excel Picture 4

Step 4: Press the key combination Ctrl + Shift + Enter to get the results:

MINVERSE function - The function returns the inverse matrix of a given matrix in Excel Picture 5

Thus, with a simple operation, you can immediately find the inverse matrix of a given matrix.

Good luck!

David Pac

Update 19 May 2020

You should read it

May be interested

CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
chisq.inv function: the function returns the inverse of the probability of the left end of the distribution when squared. support functions from the excel 2010 version. syntax: chisq.inv (probability, deg_freedom)
NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel
norm.s.inv function: the function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. support from excel 2010 onwards. syntax: norm.s.inv (probability)
NORMINV function - The function returns the inverse of the cumulative distribution in Excel
the following article details how to use the norminv function - the function returns the inverse of the cumulative distribution in excel.
TINV function - The function returns the inverse of the Student's t-distribution in Excel
tinv function: the tinv function supports the calculation of the inverse value of the student's t-distribution associated with the student's 2-t distribution in excel.
Matrix functions in Excel
today i introduce to you 3 matrix functions commonly used in excel. the article will guide in detail the syntax and specific examples for each matrix function, hoping to help you a lot in your work.
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
F.TEST function - The function returns the result of the F - test in Excel
f.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
GAMMA function - The function returns the gamma function value in Excel
gamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)