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:
Step 1: In the cell to calculate the inverse matrix, enter the formula: MINVERSE (D6: D8) .
Step 2: After entering the formula, press Enter to get the results:
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:
Step 4: Press the key combination Ctrl + Shift + Enter to get the results:
Thus, with a simple operation, you can immediately find the inverse matrix of a given matrix.
Good luck!
You should read it
- Matrix functions in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
- FISHERINV function - Function that returns the inverse of the Fissher transformation in Excel
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
- Answer common questions about dot matrix printers
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
Maybe you are interested
Understanding the intricate Dynamics of Oil Trade with the Petro-Market Matrix
Eisenhower Matrix and To-Do List: Which Time Management Style Is Right For You?
Matrix functions in Excel
The Matrix 4, in turn, announced a production suspension because of Covid-19, Keanu Reeves' Day in 2021 could be canceled.
How to Use MatLab to Solve Matrix Equations and Perform Statistical Analysis
How to Create a Matrix, Vector, and Cell Array in MATLAB