[Solved]-Question 2 20 Points Write Following Set Equations Matrix Form Excel Solve Solutions Using Q37192027

Hi, I need some excel help. Thank you in advance.

Question 2 (20 points) (a) Write the following set of equations in matrix form in Excel. Solve the solutions using matrix methods. 2×1 + 2x, + 2×3 + 2×4 1 X1-X2-X3-2X4- 7×1 – 3×2 + 8×3 + 4×4-4 Given the following matrices and scalars. 4 4 !5 4 3 6 (b) Compute A + B using array math in Excel (c) Compute A * Cusing array math in Excel (d) Compute kiA * kiB using array math in Excel Show transcribed image text Question 2 (20 points) (a) Write the following set of equations in matrix form in Excel. Solve the solutions using matrix methods. 2×1 + 2x, + 2×3 + 2×4 1 X1-X2-X3-2X4- 7×1 – 3×2 + 8×3 + 4×4-4 Given the following matrices and scalars. 4 4 !5 4 3 6 (b) Compute A + B using array math in Excel (c) Compute A * Cusing array math in Excel (d) Compute kiA * kiB using array math in Excel

Expert Answer

---

Answer to Question 2 (20 points) (a) Write the following set of equations in matrix form in Excel. Solve the solutions using matri… . . .