[go: up one dir, main page]
Scribd
Upload
163 views9 pages

Matrix Functions in Excel: Presented by DR Yousif Hummaida Ahmed Ref:Microsoft Excell Helpfle

This document discusses various matrix functions in Excel including MINVERSE, MMULT, and TRANSPOSE. It provides instructions on how to define matrix names, input matrix data, calculate the inverse of a matrix using MINVERSE, multiply matrices using MMULT, and transpose a matrix using TRANSPOSE. Key steps include defining matrix names, highlighting cell ranges and using keyboard shortcuts like F2 and Shift-Ctrl-Enter to input matrix functions and calculate results.

Uploaded by

Dr Yousif Hummaida
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
163 views9 pages

Matrix Functions in Excel: Presented by DR Yousif Hummaida Ahmed Ref:Microsoft Excell Helpfle

This document discusses various matrix functions in Excel including MINVERSE, MMULT, and TRANSPOSE. It provides instructions on how to define matrix names, input matrix data, calculate the inverse of a matrix using MINVERSE, multiply matrices using MMULT, and transpose a matrix using TRANSPOSE. Key steps include defining matrix names, highlighting cell ranges and using keyboard shortcuts like F2 and Shift-Ctrl-Enter to input matrix functions and calculate results.

Uploaded by

Dr Yousif Hummaida
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Matrix Functions in 

Excel

Presented by Dr Yousif Hummaida


Ahmed
Ref:Microsoft Excell helpfle
Matrix data input
• Input the numbers of matrix and vector
• Tell MS Excel the name of this matrix by menu
Formulas-Define Name.
• A defined-name dialog will appear and type
the name of matrix and refer to the range of
the matrix , then click OK. In a similar way, you
define the name of vector .  
Define name for a data input
Naming your data
• Alternatively you can highlight the data and
right-click the mouse, then select define name
from the drop list; much easier please read
help file for your excel version
MINVERSE
• In a cell where do you want to put the inverse
of matrix , you type =MINVERSE( ) .
• It will give you only one number. Now using
the mouse highlight the range where do you
want to put the inverse of matrix.
• Because you know that the size of inverse is
also 3 by 3 matrix, highlight only that range.
While highlighting, press F2 and then Shift-
Ctrl-Enter. You will get the inverse of matrix .
MMULT
• 5. Now you define name of inverse matrix and
use matrix multiplication function to get the
solution. To do that, in the cell where do you
want to put the solution, type
=MMULT(Inverse_A,b).
MMULT
MMULT
• It will give you only one number. Now using
the mouse highlight the range where do you
want to put the solution.
• Because you know that the size of solution is a
single column with 3 rows, highlight only that
range.
• While highlighting, press F2 and then Shift-
Ctrl-Enter and you will get the solution.  
Transpose
• This is the only matrix function that does not
start with the letter M.
• Syntax =Transpose(array)
• For each matrix, highlight only the range of
cells that is enough for size of the solution.
• While highlighting, press F2 and then Shift-
Ctrl-Enter and you will get the solution.  

You might also like