Table of Contents
Matrix multiplication is a mathematical operation in which two matrices are multiplied to produce a new matrix. This process is commonly used in various fields such as statistics, economics, and engineering. In Excel, matrix multiplication can be performed using the MMULT function, which takes two or more arrays as inputs and returns the product matrix. Some examples of using the MMULT function in Excel include calculating the total cost of a product by multiplying the unit price matrix with the quantity matrix, or finding the correlation between two sets of data by multiplying their respective covariance matrices. Overall, Excel provides a convenient and efficient way to perform matrix multiplication and analyze data in a matrix format.
Perform Matrix Multiplication in Excel (With Examples)
You can use the MMULT function in Excel to perform matrix multiplication.
This function uses the following basic syntax:
MMULT(array1, array2)
where:
- array1, array2: The two matrices you’d like to multiply.
The following examples show how to use the MMULT function to perform the following matrix multiplications in Excel:
- (2×2) by (2×2) Matrix Multiplication
- (2×2) by (2×3) Matrix Multiplication
- (3×3) by (3×2) Matrix Multiplication
Let’s jump in!
Example 1: (2×2) by (2×2) Matrix Multiplication
The following screenshot shows how to multiply a (2×2) matrix with another (2×2) matrix in Excel:
We typed the following formula in cell G2 to perform this matrix multiplication:
=MMULT(A2:B3, D2:E3)
Here are the actual formulas that Excel used to perform this matrix multiplication:
This results in the following 2×2 matrix:
Example 2: (2×2) by (2×3) Matrix Multiplication
The following screenshot shows how to multiply a (2×2) matrix with a (2×3) matrix in Excel:
We typed the following formula in cell H2 to perform this matrix multiplication:
=MMULT(A2:B3, D2:F3)
Here are the actual formulas that Excel used to perform this matrix multiplication:
This results in the following 2×3 matrix:
Example 3: (3×3) by (3×2) Matrix Multiplication
The following screenshot shows how to multiply a (3×3) matrix with a (3×2) matrix in Excel:
We typed the following formula in cell H2 to perform this matrix multiplication:
=MMULT(A2:C4, E2:F4)
Here are the actual formulas that Excel used to perform this matrix multiplication:
This results in the following 3×2 matrix:
Note: You can find the complete documentation for the MMULT function in Excel .
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I perform matrix multiplication in Excel? Can you provide some examples?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-excel-can-you-provide-some-examples/
stats writer. "How do I perform matrix multiplication in Excel? Can you provide some examples?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-excel-can-you-provide-some-examples/.
stats writer. "How do I perform matrix multiplication in Excel? Can you provide some examples?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-excel-can-you-provide-some-examples/.
stats writer (2024) 'How do I perform matrix multiplication in Excel? Can you provide some examples?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-excel-can-you-provide-some-examples/.
[1] stats writer, "How do I perform matrix multiplication in Excel? Can you provide some examples?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I perform matrix multiplication in Excel? Can you provide some examples?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.