Use The MINVERSE Function

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Use The MINVERSE Function

This video tutorial shows how to use find the inverse of a matrix using the MINVERSE function in Excel.
http://quantunet.com/excel2003/skills/sample/the_minverse_function.html
  • Total Hits: 11465

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 140 votes

  • Category: MS Excel/Functions

  • Submitted on: 2008-04-27 00:39:22

  • Submitted By: Devesh Khanna

  • Set as Favorite

Description:

# Type " =MINVERSE( ".
# Enter the reference for the "known_y" values "B3:D5".
# Type ")" then press the "Enter" key.
# Select the range F3:H5.
# Press the "F2" key the press the Ctrl + Shift + Enter keys.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.57%  54
 Two starsTwo star  Vote LeftVote MiddleVote Right 10%  14
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.43%  16
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.71%  15
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.29%  41

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements