Table of Contents
Matrix multiplication is a mathematical operation that involves multiplying two matrices to obtain a new matrix. In Google Sheets, this can be done by using the MMULT function. To perform matrix multiplication in Google Sheets, you must first enter the matrices in two separate cells, making sure that the number of columns in the first matrix is equal to the number of rows in the second matrix. Then, in a third cell, use the MMULT function to multiply the two matrices. The resulting matrix will be displayed in the third cell. This function can be used for both square and non-square matrices, making it a useful tool for performing complex calculations in Google Sheets.
Perform Matrix Multiplication in Google Sheets
You can use the MMULT function in Google Sheets to perform matrix multiplication.
This function uses the following basic syntax:
MMULT(matrix1, matrix2)
where:
- matrix1, matrix2: 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 Google Sheets:
- (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 Google Sheets:
We typed the following formula in cell G2 to perform this matrix multiplication:
=MMULT(A2:B3, D2:E3)
Here are the actual formulas that Google Sheets 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 Google Sheets:
We typed the following formula in cell H2 to perform this matrix multiplication:
=MMULT(A2:B3, D2:F3)
Here are the actual formulas that Google Sheets 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 Google Sheets:
We typed the following formula in cell H2 to perform this matrix multiplication:
=MMULT(A2:C4, E2:F4)
Here are the actual formulas that Google Sheets 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 Google Sheets .
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How do I perform matrix multiplication in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-google-sheets/
stats writer. "How do I perform matrix multiplication in Google Sheets?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-google-sheets/.
stats writer. "How do I perform matrix multiplication in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-google-sheets/.
stats writer (2024) 'How do I perform matrix multiplication in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-perform-matrix-multiplication-in-google-sheets/.
[1] stats writer, "How do I perform matrix multiplication in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I perform matrix multiplication in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.