This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Then type in the MINVERSE equation as follows: =MINVERSE (a1:e5) , where a1:e5 are the cells where the original matrix is at. Or you may select data cells by dragging a window as you usually do in Excel. Your equation will appear on the upper left-hand cell of the highlighted cells where the inverted matrix is going to be. Once you type in the function, and this is very important, instead of just pressing enter (this will give you back just one result, placed on the upper left hand cell), YOU MUST PRESS CTRL-SHIFT-ENTER at the same time, NOT JUST ENTER. This will then give you the inverted matrix in ALL the highlighted cells....
View Full Document
- Spring '09