Difference between revisions of "Manuals/calci/MDETERM"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...")
 
 
(19 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
<div style="font-size:30px">'''MDETERM(a)'''</div><br/>
 +
*<math>a</math> is the array of numeric elements.
 +
**MDETERM(), returns the matrix determinant of an array.
  
Syntax
+
==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 <math>A</math> is denoted by <math>det(A)</math> or <math>|A|</math>.
 +
*Let <math>A</math> be 2x2 matrix with the elements
 +
<math>A = \begin{bmatrix}
 +
a & b \\
 +
c & d \\
 +
\end{bmatrix}
 +
</math>
 +
*Then <math>det(A)=ad-bc</math>, where <math>a,b,c,d</math> all are real numbers.
 +
*Let <math>A</math> be the 3x3 matrix with the elements
 +
<math>A = \begin{bmatrix}
 +
a & b & c  \\
 +
d & e & f  \\
 +
g & h & i  \\
 +
\end{bmatrix}
 +
</math>
 +
Then <math>|A|=a\begin{vmatrix}
 +
e & f \\
 +
h & i
 +
\end{vmatrix} -b\begin{vmatrix}
 +
d & f \\
 +
g & i
 +
\end{vmatrix} +c\begin{vmatrix}
 +
d & e \\
 +
g & h
 +
\end{vmatrix}</math>:
 +
<math>|A| =a(ei-fh)-b(di-fg)+c(dh-eg)</math>
 +
*Let <math>A</math> be a square matrix of order <math>n</math>. Write <math>A = (a_{ij})</math>,
 +
*Where <math>a_{ij}</math> is the entry on the <math>i^{th}</math> row and <math>j^{th}</math> column and <math>i=1</math> to <math>n</math> & <math>j=1</math> to <math>n</math>.
 +
*For any <math>i</math> and <math>j</math>, set <math>A_{ij}</math> (called the co-factors), then the general formula for determinant of the matrix <math>A</math> is,
 +
<math>|A|=\sum_{j=1}^n a_{ij} A_{ij}</math>, for any fixed <math>i</math>.
 +
Also<math>|A|=\sum_{i=1}^n a_{ij} A_{ij}</math>, for any fixed <math>j</math>.
 +
*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
  
</div></div>
+
==ZOS==
----
+
*The syntax is to calculate determinant of a matrix in ZOS is <math>MDETERM(a)</math>.
<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
+
**<math>a</math> is the array of numeric elements.
 +
*For e.g.,MDETERM([[2.3,4.1,5.9],[3.5,6.2,1.3],[2.8,9.1,8.4]])
  
Remarks
+
==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
  
</div></div>
+
==Related Videos==
----
 
<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
 
  
Examples
+
{{#ev:youtube|OU9sWHk_dlw|280|center|Determinant of Matrix}}
  
</div></div>
+
==See Also==
----
+
*[[Manuals/calci/MINVERSE  | MINVERSE ]]
<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
+
*[[Manuals/calci/MMULT  | MMULT ]]
----
 
<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
 
  
<font size="5">Description</font>
+
==References==
 +
[http://en.wikipedia.org/wiki/Determinant Determinant ]
  
</div></div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">MDETERM</font> </font>'''</div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>
 
  
'''MDETERM'''('''a''')
 
  
Where a is a numeric array, have same number of rows and columns.
+
*[[Z_API_Functions | List of Main Z Functions]]
  
</div></div>
+
*[[ Z3 Z3 home ]]
----
 
<div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman"> 
 
 
 
* a can be given as a cell range, {1,2,3;4,5,6;7,8,9}; or as a name to either of these.
 
* Matrix determinants are generally used for solving systems of mathematical equations that involve several variables.
 
 
 
</font>
 
 
 
<font face="Times New Roman"> </font>
 
 
 
</font></div></div>
 
----
 
<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman"> 
 
 
 
MDETERM function gives you the matrix determinant of an array.
 
 
 
</font></font></div></div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
 
 
 
<font size="3"><font face="Times New Roman">                C1       C2         C3      C4</font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman">R1            2          3            4         5</font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman">R2            2          5            1         4</font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman">R3           5          5             4         6</font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman">R4           4          1             5         2</font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman"></font></font>
 
 
 
<font size="3"><font face="Times New Roman">That is MDETERM (B2:E5) is 84</font></font>
 
 
 
<font size="3"><font face="Times New Roman"> </font></font>
 
 
 
</div></div>
 
----
 
<div id="6SpaceContent" class="zcontent" align="left">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class="  " |
 
<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
| Column1
 
| class="  " | Column2
 
| class="  " | Column3
 
| class="  " | Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="sshl_f" | 2
 
| class="sshl_f" | 3
 
| class="sshl_f" | 4
 
| class="sshl_f" | 5
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f   " | 2
 
| class="sshl_f" | 5
 
| class="sshl_f" | 1
 
| class="sshl_f" | 4
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 5
 
| class="sshl_f" | 5
 
| class="sshl_f" | 4
 
| class="sshl_f" | 6
 
|- class="even"
 
| Row4
 
| class="sshl_f" | 4
 
| class="sshl_f" | 1
 
| class="sshl_f" | 5
 
| class="sshl_f " |
 
<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>2
 
|- class="odd"
 
| class=" " | Row5
 
| class="sshl_f" | 84
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| Row6
 
| class="sshl_f SelectTD SelectTD" |
 
<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|}
 
 
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 
</div></div></div></div></div></div></div></div></div></div></div></div>
 

Latest revision as of 17:01, 24 July 2018

MDETERM(a)


  • is the array of numeric elements.
    • MDETERM(), returns the matrix determinant of an array.

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

ZOS

  • The syntax is to calculate determinant of a matrix in ZOS is .
    • is the array of numeric elements.
  • For e.g.,MDETERM([[2.3,4.1,5.9],[3.5,6.2,1.3],[2.8,9.1,8.4]])

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

Related Videos

Determinant of Matrix

See Also

References

Determinant