Question
Asked Nov 19, 2019
17 views

Solve the following system of equations using Matrix Algebra.

     7X + 4Y - 8Z =   50

     5X - 3Y + 5Z =   45

     3X + 2Y + 2Z =  40

Please show work in excel

check_circle

Expert Answer

Step 1

To determine the solution of the system of equations in excel.

Step 2

Given:

7X + 4Y - 8Z = 50

5X - 3Y + 5Z = 45

3X + 2Y + 2Z = 40

Step 3

Insert the coefficient matrix in the cells (B3:D5) of the excel sheet.

Select the cells (B8:D10) and enter the formula in the formula bar “=MINVERSE(B3:D5)” and press “ctrl + shift + enter&rd...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Algebra

Linear Programming

Related Algebra Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Ayden started with $450 in his bank account. He had 7 withdrawals of $13.50. How much does he have i...

A: Given,

question_answer

Q: Find the present value of $30,000 due in 6 years at an interest rate of 8%/year compounded monthly.

A: Given:Find the present value of $30,000 due in 6 years at an interest rate of 8%/year compounded mon...

question_answer

Q: x/x+9 + 2/x-4 = -2x+99/x2 +5x-36

A: The given equation is

question_answer

Q: how many sticks could be cut into 8 parts using only 5 cuts

A: One stick is cut in two parts as shown in below figure.

question_answer

Q: There were 370 tickets purchased for a major league baseball game. The lower boxlower box   tickets ...

A: Given,The total number of tickets purchased = 325The lower box tickets cost=$12.50The upper box tick...

question_answer

Q: The president of a company traveled 1700 mi by jet and 300 mi on a prop plane. The rate of the jet w...

A: Click to see the answer

question_answer

Q: how to use a calculator to approximate an exponential function like 23.4 or 32.4 Or can you show me...

A: In order to approximate the value 23.4 or 32.4, turn on T1-83 calculator and then click the MODE but...

question_answer

Q: How long will it take an investment of $8,000 to grow to $10,000 if the investment earns interest at...

A: The compound interest formula ( if the interest is compounded on daily basis) is given by:

question_answer

Q: THE PRINCIPAL P IS BORROWED  AND THE LOANS FUTURE VALUE A AT THE TIME  T IS GIVEN. DETERMINE THE LOA...

A: It is given that, the principal P is 5000, the loan future value A is 5325 and time T is 1 year.Obta...