+ Reply to Thread
Results 1 to 2 of 2

Matrices question

Hybrid View

  1. #1
    Registered User
    Join Date
    03-03-2008
    Posts
    1

    Matrices question

    hello I am an excel newbie and I desperately need help with this IT task my teacher assigned for me. I completely do not know anything about matrices in excel, so I believe this is the place where I should seek help. Attached is the assignment
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936
    NOTE:
    Depending on the type of school your're in, handing in someone else's work could be considered cheating or plagerism and could get you kicked out!
    However, to get you started:
    Given the system of equations:

    2x - 6y + 3z = -12
    3x - 2y + 5z = -4
    4x + 5y -2z = 10

    The matrix equations are:

    |2	-6	3  |   |x|     | -12|
    |3	-2	5  |   |y| =   |-4  |
    |4	5	-2 |   |z|     |10  |


    suppose you type in cells A1 thru C3 the following:
    2	-6	3
    3	-2	5
    4	5	-2
    This is your matrix A

    then in cell G1, say, enter the formula "=MDETERM(A1:C3)" to calculate the determinant of the matrix.

    Next, for the inverse, you will select a range of nine cells, say, L1 thru N3.
    Then, with those nine cells selected, type in the equation bar "=MINVERSE(A1:C3)" ---> press Ctrl + Shift + Enter.
    notice that XL puts braces {} around the formula and that nine values (the inverse matrix) will be entered into the selected cells, etc. as a start........
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1