Manuals/calci/MDETERM

Revision as of 04:06, 31 December 2013 by Abin (talk | contribs) (→‎Description)
MDETERM(arr)


  • where is the array of numeric elements


Description

  • This function gives the determinant value of a matrix.
  • To calculate the determinant of the matrix we can choose only square matrix.
  • i.e., Number rows and number of columns should be equal.
  • Determinant of the identity matrix is always 1.
  • Determinant of the matrix A is denoted by det(A) or |A|.
  • Let A be 2x2 matrix with the elements

 

  • Then det(A)=ad-bc, where a,b,c,d all are real numbers.
  • Let A be the 3x3 matrix with the elements

  Then  :  

  • Let   be a square matrix of order  . Write  ,
  • Where   is the entry on the   number of rows and   number of columns and   to   &   to  .
  • For any   and  , set   (called the co-factors), then the general formula for determinant of the matrix A ,

 , for any fixed  . Also , for any fixed  .

  • This function will give the result as error when
1. Any one of the element in array is empty or contain non-numeric
2. Number of rows is not equal to number of columns

Examples

  1. =MDETERM({6,4,8;3,6,1;2,4,5}) = 104
  2. =DETERM({-5,10;6,-8}) = -20
  3. =MDETERM({1,0,2,1;4,0,2,-1;1,4,5,2;3,1,2,0}) = 17
  4. =MDETERM({1,2,3;5,2,8}) = NAN

See Also

References