Difference between revisions of "Manuals/calci/MDETERM"

From ZCubes Wiki
Jump to navigation Jump to search
Line 42: Line 42:
 
==Examples==
 
==Examples==
 
#=MDETERM({6,4,8;3,6,1;2,4,5}) = 104
 
#=MDETERM({6,4,8;3,6,1;2,4,5}) = 104
#=DETERM({-5,10;6,-8}) = -20
+
#=MDETERM({-5,10;6,-8}) = -20
 
#=MDETERM({1,0,2,1;4,0,2,-1;1,4,5,2;3,1,2,0}) = 17
 
#=MDETERM({1,0,2,1;4,0,2,-1;1,4,5,2;3,1,2,0}) = 17
 
#=MDETERM({1,2,3;5,2,8}) = NAN
 
#=MDETERM({1,2,3;5,2,8}) = NAN
  
 
==See Also==
 
==See Also==
 +
*[[Manuals/calci/MINVERSE  | MINVERSE ]]
 +
*[[Manuals/calci/MMULT  | MMULT ]]
 +
 +
  
 
==References==
 
==References==

Revision as of 23:53, 31 December 2013

MDETERM(arr)


  • is the array of numeric elements

Description

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

  • Then , where all are real numbers.
  • Let be the 3x3 matrix with the elements

Then :

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

, 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. =MDETERM({-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