{"id":18353,"date":"2016-10-17T16:23:23","date_gmt":"2016-10-17T16:23:23","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18353"},"modified":"2016-10-17T16:28:13","modified_gmt":"2016-10-17T16:28:13","slug":"spreadsheets-matrix-inverse-on-excel-or-officelibre-calc","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-matrix-inverse-on-excel-or-officelibre-calc\/","title":{"rendered":"Spreadsheets: Matrix inverse on Excel or LibreOffice Calc"},"content":{"rendered":"

The MINVERSE() function can be tricky to use; the tutor tells how.<\/h1>\n

Example: find the inverse of matrix A:<\/p>\n\n\n\n\n
-5<\/td>\n0<\/td>\n1<\/td>\n<\/tr>\n
3<\/td>\n8<\/td>\n9<\/td>\n<\/tr>\n
0<\/td>\n1<\/td>\n0<\/td>\n<\/tr>\n<\/table>\n

Solution:<\/p>\n

    \n
  1. \nEnter the matrix in Excel or LibreOffice Calc. Let’s imagine, for this example, you use the 3×3 range a1:c3.<\/li>\n
  2. Select a cell to the right, away from the cells you’ve used. Drag across and down so that you’ve captured a 3×3 area.<\/li>\n
  3. Click into the formula box and type =minverse(a1:c3)<\/span> but don’t press enter!<\/strong><\/li>\n
  4. Hold down both Ctrl and Shift, then press Enter.<\/li>\n<\/ol>\n

    Hopefully you see the result<\/p>\n\n\n\n\n
    -0.1875<\/td>\n0.020833<\/td>\n-0.166671<\/td>\n<\/tr>\n
    0<\/td>\n0<\/td>\n1<\/td>\n<\/tr>\n
    0.0625<\/td>\n0.104167<\/td>\n-0.83333<\/td>\n<\/tr>\n<\/table>\n

    Source:<\/p>\n

    www.excelfunctions.net<\/a><\/p>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The MINVERSE() function can be tricky to use; the tutor tells how. Example: find the inverse of matrix A: -5 0 1 3 8 9 0 1 0 Solution: Enter the matrix in Excel or LibreOffice Calc. Let’s imagine, for …<\/p>\n

    Spreadsheets: Matrix inverse on Excel or LibreOffice Calc<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[302,3],"tags":[1078,1974,1074,1973],"class_list":["post-18353","post","type-post","status-publish","format-standard","hentry","category-linear-algebra","category-math","tag-excel","tag-finding-inverse-of-a-matrix-with-a-spreadsheet","tag-libreoffice-calc","tag-minverse-function"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18353"}],"version-history":[{"count":16,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18353\/revisions"}],"predecessor-version":[{"id":18369,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18353\/revisions\/18369"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}