excel

1. In an Excel worksheet titled “Solver”, solve the following system of non-linear equations

using the Solver and find u, v, and t.

Eqn 1. 2u2 – 4v – t =0

Eqn 2. 5u – 6v + 2t = 8

Eqn 3. 2u + 4v2 – 5t = 2

2. The solver in Excel can also be used to solve systems of linear equations a well. Solve the

following system of linear equations using the solver and find w, x, y, z. Note, this is the

same problem as last week, so your answer should match.

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