excel

On a worksheet titled “Problem 1,” solve the following system of linear equations using the matrix solver and find w, x, y, z. Eqn 1. 3w + 4.2x – 4y – 2z = 1 Eqn 2. w – 2x + 3.2y – z = -3 Eqn 3. 2w + 0.5x + 2.1y + 3.3z =5 Eqn 4. 5w – 2x + 4.1y + 0.8z = -2.2 2. In the engineering statics course (CE 2210), it’s possible that you may have to solve a problem with six equations and six unknowns. The equations for a static equilibrium problem is given below. There are five unknown forces (F1 – F5) with units of pounds (lb) and one distance (d) with units of feet (ft). On a sheet titled “Problem 2” and given the equations below, solve for the unknowns: S Fx = 0: 200 lb – (cos 20˚)F1 + (3/5)F3 + 120 lb + 0.5F4 = 0 S Fy = 0: -38.6 lb + (sin 20˚)F1 + (4/5)F3 +10.45 lb – F5 = 0 S Fz = 0: (cos 20˚) (cos 33˚)F2 -82 lb – 0.707F4 = 0 S Mx = 0: (2.8 ft)F1 – (5.2 ft)F3 +525 lb·ft = 0 S My = 0: (3.4 ft)F4 + (2.4 ft)F5 – 235.2 lb·ft = 0 S Mz = 0: (10.45 lb)d + (6.1 ft)F2 + 301.3 lb·ft = 0