excel

1. 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.5*F4 = 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.707*F4 = 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