Difference between revisions of "Manuals/calci/MDETERM"
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 | ||
− | #= | + | #=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
- =MDETERM({6,4,8;3,6,1;2,4,5}) = 104
- =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,2,3;5,2,8}) = NAN
See Also