在学习矩阵外积(outer product)时,第一次使用了TRANPOSE函数,在此标记一下。
已知矩阵X:
X | |
3 | 1 |
2 | 4 |
1 | 2 |
及矩阵Y:
Y | |
1 | 2 |
2 | 4 |
3 | 1 |
求:XY^T(Y^T表示矩阵Y的转置矩阵)。
用Excel矩阵乘法函数(MMULT)和转置函数(TRANSPOSE)直接计算出结果为:
XY^T | ||
5 | 10 | 10 |
10 | 20 | 10 |
5 | 10 | 5 |
显示公式为:
XY^T | ||
=MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) |
=MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) |
=MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) | =MMULT(B32:C34,TRANSPOSE(F32:G34)) |
参考内容:
TRANSPOSE函数的详细说明,可参考以下文章:
https://www.excelfunctions.net/excel-transpose-function.html