WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Inverse Matrix in Excel

Inverse Matrix in Excel

By Dhanamma PandulaDhanamma Pandula | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Excel Inverse Matrix

An inverse matrix is defined as the reciprocal of a square matrix that is a non-singular matrix or invertible matrix (determinant is not equal to zero). It is hard to determine the inverse for a singular matrix. The inverse matrix in excel has an equal number of rows and columns to the original matrix.

One interesting thing about the inverse matrix is that by multiplying it with the original matrix, we will get the identity matrix that has all diagonal values equal to one. Inverse matrices are applied in the linear algebra in solving the equations. To determine the inverse of a matrix, different types of methods are available, including manual calculation and automated calculation. The automated calculation involves the use of Excel functions. Excel, the matrix inverse calculation process is simplified by applying an inbuilt function of MINVERSE in excel.

Inverse-Matrix-Excel

How to Inverse a Matrix in Excel?

Excel MINVERSE function is helpful in returning the array or matrix inverse. The input matrix must be a square matrix with all numeric values with an equal number of columns and rows in size. The INVERSE matrix will have the same dimensions as the input matrix.

Purpose: The purpose of this function is to find out the inverse of a given array

Return value: This function returns the inverse matrix with equal dimensions

Syntax: The syntax of the MINVERSE function is

minverse function

Array: The array should consist of only either positive or negative numerical values.

The INVERSE function is used in two ways in Excel, including typing manually and inserting from the Math and Trig functions under the “Formula” tab

Uses

The inverse matrix in Excel is used for various purposes. Those include

  • System of linear equations are solved in Excel using the inverse matrix
  • Inverse matrices are used in non-linear equations, linear programming in excel, and finding the integer solutions to system equations
  • Inverse matrices have applications in the data analysis, especially in the least square regression to determine the various statistical parameters and values of variances and covariance’s
  • Resolving problems associated with the input and output analysis in economics and business, inverse matrices are used

Examples

You can download this Inverse Matrix Excel Template here – Inverse Matrix Excel Template

Example#1

Determining the inverse of a 2×2 square matrix in Excel

For this example, consider the following matrix A.

Inverse Matrix Example 1.1

Step 1: Enter the matrix A into the Excel sheet, as shown in the below-mentioned figure.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Inverse Matrix Example 1.2

The range of the matrix is that B2: C3.

Step 2: Select the range of cells to position the inverse matrix A-1 on the same sheet.

Inverse Matrix Example 1.3

Step 3: After selecting the required cells, enter the MINVERSE function formula into the formula bar. It needs to be ensured that the formula entered while the cells are still selected.

Inverse Matrix Example 1.4

Step 4: Enter the range of the array or matrix, as shown in the screenshot.

Inverse Matrix Example 1.5

Step 5: After entering the formula, press the ENTER key in combination with the CTRL and SHIFT key to convert the normal formula to an array formula to produce all elements of the inverse matrix at a time. The formula will be changed as {=MINVERSE (B2:C3)}

Inverse Matrix Example 1.6

Step 6: The resultant inverse matrix is produced as:

Inverse Matrix Example 1.7

Here, one thing we can observe is that the size of the input matrix and the inverse matrix is the same as 2×2.

Example #2

Determining the inverse of a 3×3 square matrix in Excel

For this example, consider the following matrix A.

Inverse Matrix Example 2

Step 1: Enter the matrix A into the Excel sheet, as shown in the below-mentioned figure.

Inverse Matrix Example 2.1

The range of the matrix is that B2: D4.

Step 2: Select the range of cells to position the inverse matrix A-1 on the same sheet.

Inverse Matrix Example 2.2

Step 3: After selecting the required cells, enter the MINVERSE function formula into the formula bar. It needs to be ensured that the formula entered while the cells are still selected.

Inverse Matrix Example 2.3

Step 4: Enter the range of the array or matrix, as shown in the screenshot.

Inverse Matrix Example 2.4

Step 5: After entering the formula, press the ENTER key in combination with the CTRL and SHIFT key to convert the normal formula to an array formula to produce all elements of the inverse matrix at a time. The formula will be changed as {=MINVERSE (B2: D4)}

Example 2.5

Step 6: The resultant inverse matrix is produced as:

Example 2.6

Here, one thing we can observe is that the size of the input matrix and the inverse matrix is the same as 3×3.

Example#3

Determining the inverse of the Identity matrix

Consider the 2×2 identity matrix for this example.

Step 1: Enter the matrix I into the Excel sheet

Example 3.1

Step 2: Select the range of cells to position the inverse matrix I-1 on the same sheet.

Example 3.2

Step 3: After selecting the required cells, enter the MINVERSE function formula into the formula bar.

Example 3.3

Step 4: Enter the range of the array or matrix, as shown in the screenshot.

Example 3.4

Step 5: Press the ENTER key in combination with CTRL and SHIFT key to convert the normal formula to an array formula. The formula will be changed as {=MINVERSE (B2:C3)}

Example 3.5

Step 6: The resultant inverse matrix is produced as:

Example 3.6

From this, it is observed that the inverse of an identity matrix and identity matrix are the same.

Things to Remember

  • While using the MINVERSE function in Excel, #value error will occur if the matrix contained non-numerical values, empty cells, and having a different number of columns and rows.
  • #NUM error is displayed in the provided matrix is a singular matrix
  • #N/A error is displayed in the cells of the resulting inverse matrix is out of range. MINVERSE function results in the #N/A error in extra cells selected
  • The MINVERSE function must be entered as the array formula in excel into the spreadsheet.

Recommended Articles

This has been a guide to Excel Inverse Matrix. Here we discussed how to inverse Matrix in Excel using MINVERSE() Function with examples and a downloadable excel template. You can learn more about excel from the following articles –

  • Covariance Matrix in Excel
  • New Line in Excel
  • Matrix Multiplication in Excel
  • Create Correlation Matrix in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Inverse Matrix Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More