Given the system of four equation in six unknowns as shown: 3A + 2B 4C +...

 

Transcribed Image Text:

Given the system of four equation in six unknowns as shown: 3A + 2B 4C + 5D +3E+ 2F = 74 - 4A 5B + 2C+ 3D - 2E+ 5F = 53 6A 3B+7C-2D+3E+ 5F = -6 - -2A + 4B-3C + 7D-4E+ 3F = 120 3A + 7B 4C + 5D + 6E + 2F = 87 -4A 5B-3C-6D+ 7E+ 2F = -49 Enter the coefficient matrix and label it as Coeff. Enter the result (right side) matrix and label it as Rslt Compute the transform matrix of Coeff using the EXCEL function. Label the result as Tform. Compute the determinate of the coefficient matrix. Label your result as Detr. Compute the inverse of the coefficient matrix. Label your result as Inve. Compute the product of the Inve and the Rslt matrices. Label your result as Solution. Given the system of four equation in six unknowns as shown: 3A + 2B 4C + 5D +3E+ 2F = 74 - 4A 5B + 2C+ 3D - 2E+ 5F = 53 6A 3B+7C-2D+3E+ 5F = -6 - -2A + 4B-3C + 7D-4E+ 3F = 120 3A + 7B 4C + 5D + 6E + 2F = 87 -4A 5B-3C-6D+ 7E+ 2F = -49 Enter the coefficient matrix and label it as Coeff. Enter the result (right side) matrix and label it as Rslt Compute the transform matrix of Coeff using the EXCEL function. Label the result as Tform. Compute the determinate of the coefficient matrix. Label your result as Detr. Compute the inverse of the coefficient matrix. Label your result as Inve. Compute the product of the Inve and the Rslt matrices. Label your result as Solution.

Answer rating: 100% (QA)

ANSWER The matrix functions available in excel are 1 MDETERM To find ... View the full answer