Difference between revisions of "Manuals/calci/MMULT"

Latest revision as of 17:03, 24 July 2018

MMULT(a,b)

where and are the array of two matrices.
- MMULT(), returns the matrix product of two arrays.

Description

This function gives product of two matrices.
Matrix multiplication is of two types:

Type 1: A scalar (a constant) is multiplied with the each element of the matrix.
Type 2: Multiplication of two matrices.

We can do the matrix multiplication when the number of columns in the first matrix equals the number of rows in the second matrix.
For e.g. 4x2 matrix can multiply with 2x3. The matrix product of two arrays $a$ and $b$ is: $x_{ij}=\sum _{k=1}^{n}a_{ik}.b_{kj}$ where $i$ is the row number and $j$ is the column number.
i.e Multiply the elements of each row of 1st matrix by elements of each column of 2nd matrix.
So the resultant matrix is of the order: Rows of 1st matrix × Columns of 2nd.
For e.g If we multiply a 4x2 matrix with a 2x3 matrix, the product matrix is of order 4x3.
Matrix multiplication satisfies the associative and distributive properties.But it is not satisfies the commutative property.
i.e., Let A,B and C are three matrices, then A(BC)= (AB)C (Associative property)
A(B+C)= AB+AC and (A+B)C = AC+BC (Distributive properties)
k(AB)=(kA)B=A(kB)where k is a constant.But $AB\neq BA$ (Commutative property)
This function will give the result as error when:

The number of columns in the 1st matrix is not equal to number of rows in the 2nd matrix.
In the range cell, any cells are empty or that should not be convert in to numbers.

ZOS

The syntax is to calculate MMULT in ZOS is
- where $a$ and $b$ are the array of two matrices.
For e.g.,MMULT([[2.5,4,3,7],[1,3,5,4]],[[2,5,6],[7.3,4,9],[10,4,1],[6,2,8]])

Matrix Multiplication

Examples

Example 1

Spreadsheet
	A	B	C
1	5	7	8
2	7	4
3	8
4	4	-5	9
5

From the above table values:

=MMULT(3,A1:A3)
15	21	24

=MMULT(6,A4:C4)
24	-30	54

Example 2

Matrix A
7	5
2	3
6	0
9	8

Matrix B
8	-4	11
2	7	5

Here Matrix A is of order 4x2 and Matrix B is of order 2x3.
So the Product Matrix is of order 4x3. i.e

1st Row 7*8+5*2 = 66 ; 7*(-4)+5*7 = 7 ; 7*11+5*5 = 102
2nd Row 2*8+3*2 = 22 ; 2*(-4)+3*7 = 13 ; 2*11+3*5 = 37 and so on

References

Matrix Multiplication

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''MMULT(a1,A2)'''</div><br/>
+<div style="font-size:30px">'''MMULT(a,b)'''</div><br/>
-*where a1 and a2 the array if two matrices
+*where <math>a</math> and <math>b</math> are the array of two matrices.
+**MMULT(), returns the matrix product of two arrays.
 ==Description==
-*This function gives product of two matrices.Matrix multiplication is of two types:Type1: A scalar (a constant) is multiplied with the each element of the matrix.
+*This function gives product of two matrices.
-*Type 2: multiplication of two matrices. We can do the matrix multiplication when  the number of columns in the first matrix equals the number of rows in the second matrix.
+*Matrix multiplication is of two types:
-*For e.g. 4x2 matrix can multiply with 2x3. The matrix  product of two arrays a and b is xij= summation of k=1 to n aik.bkj, where i ts the row number and j is the colun number.
+ Type 1: A scalar (a constant) is multiplied with the each element of the matrix.
+ Type 2: Multiplication of two matrices.
+*We can do the matrix multiplication when  the number of columns in the first matrix equals the number of rows in the second matrix.
+*For e.g. 4x2 matrix can multiply with 2x3. The matrix product of two arrays <math>a</math> and <math>b</math> is: <math>x_{ij}= \sum_{k=1}^n a_{ik}.b_{kj}</math> where <math>i</math> is the row number and <math>j</math> is the column number.
 *i.e Multiply the elements of each row of 1st matrix by elements of each column of 2nd matrix.
-*So the resultant matrix of the order is:Rows of 1st matrix × Columns of 2nd. For e.g .
+*So the resultant matrix is of the order: Rows of 1st matrix × Columns of 2nd.
-*If we multiply a4x2 matrix with a 2x3 matrix, the product matrix is 4x3 .
+*For e.g If we multiply a 4x2 matrix with a 2x3 matrix, the product matrix is of order 4x3.
+*Matrix multiplication satisfies the associative and distributive properties.But it is not satisfies the commutative property.
+*i.e., Let A,B and C are three matrices, then A(BC)= (AB)C (Associative property)
+*A(B+C)= AB+AC  and (A+B)C = AC+BC (Distributive properties)
+*k(AB)=(kA)B=A(kB)where k is a constant.But <math>AB \ne BA </math> (Commutative property)
 *This function will give the result as error when:
-#The number of columns in the 1st matrix is not equal to number of rows in the 2nd matrix.
+ The number of columns in the 1st matrix is not equal to number of rows in the 2nd matrix.
-#In the range cell, any cells are empty or that should not be convert in to numbers.
+ In the range cell, any cells are empty or that should not be convert in to numbers.
+==ZOS==
+*The syntax is to calculate MMULT in ZOS is <math>MMULT(a,b)</math>
+**where <math>a</math> and <math>b</math> are the array of two matrices.
+*For e.g.,MMULT([[2.5,4,3,7],[1,3,5,4]],[[2,5,6],[7.3,4,9],[10,4,1],[6,2,8]])
+{{#ev:youtube|2lQ6XsvIbck|280|center|Matrix Multiplication}}
 ==Examples==
-A student investigated the chance of getting viral fever in a school for a period that took vitamin tablets every day. The total number of students 880. In that 639 students didn't get viral fever and 241 students got fever .But the expected ratio is 1:3<br/>
+#'''Example 1'''
-'''Answer'''
+{| class="wikitable"
-*If the ratio is 1:3 and the total number of observed individuals is 880, then the expected numerical values should be: 660 will not get fever and 220 students will get fever.
+|+Spreadsheet
+|-
+! !! A !! B !! C !! D!! E
+|-
+! 1
+| 5 || 7 || 8 || ||
+|-
+! 2
+| 7 || 4 ||  ||  ||
+|-
+! 3
+| 8  ||   ||   || ||
+|-
+! 4
+| 4 ||-5  || 9  || ||
+|-
+! 5
+|  ||  ||   || ||
+|}
+'''From the above table values:'''
+ {| class="wikitable"
+ |+ =MMULT(3,A1:A3)
+ |-
+ | 15
+ | 21
+ | 24
+ |}
+ {| class="wikitable"
+ |+=MMULT(6,A4:C4)
+ |-
+ | 24
+ | -30
+ | 54
+  |}
-{| class="wikitable" style="width:50%"
+#'''Example 2'''
-|-
+{| class="wikitable"
-!
+|+Matrix A
-! No Fever
+|-
-! Get Fever
+| 7 || 5
 |-
-! Observed Values
+| 2 || 3
-| 639
-| 241
 |-
-! Expected Values
+| 6 || 0
-| 660
-| 220
 |-
-! <math>\frac{(oi-ei)^2}{ei}</math>
+| 9 || 8
-| 0.668
-| 2
 |}
-*The <math>\chi^2</math> value is 2.668
+{| class="wikitable"
-*Now <math>df=(r-1)(c-1) = (2-1)(2-1) = 1 </math>
+|+Matrix B
-*From the Chi Squared Distribution probability table with <math>df</math> is 1, the <math>\chi^2</math> value of 2.668 is  0.10.<br/>
+|-
-CHITEST(or,er) = 0.10
+| 8 || -4 ||11
+|-
+| 2 || 7  || 5
+|}
+*Here Matrix A is of order 4x2 and Matrix B is of order 2x3.
+*So the Product Matrix is of order 4x3. i.e
+#'''1st Row''' 7*8+5*2 = 66  ;  7*(-4)+5*7 = 7  ;  7*11+5*5 = 102
+#'''2nd Row''' 2*8+3*2 = 22  ;  2*(-4)+3*7 = 13  ;  2*11+3*5 = 37 and so on
+==Related Videos==
+{{#ev:youtube|OMA2Mwo0aZg|280|center|Matrix Multiplication}}
 ==See Also==
@@ Line 49: / Line 101: @@
 ==References==
-[http://en.wikipedia.org/wiki/Chi-squared_distribution  CHI-SQUARE Distribution]
+[http://en.wikipedia.org/wiki/Matrix_multiplication  Matrix Multiplication]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/MMULT"

Latest revision as of 17:03, 24 July 2018

Contents

Description

ZOS

Examples

Related Videos

See Also

References

Navigation menu

Search