EGR-103

Computer Applications in Engineering

Assignment No4

*Note – Make sure that you put your name, course and section

number, and the date in cells A1 – A3.

1. Read Chapter 11 up to page 334 in Spreadsheet Tools for

Engineers and try all of the examples given. (Not Collected)

2. Determine the POSITIVE real root for the given equation given

below using the graphical method:

x cosx 1 sin x

Save the file as GraphicSolution.xlsx.

3. Redo Problem 2 using Goal Seek. Make sure that everything is

labeled concisely in the spreadsheet. Save the file as

GOALSEEK.xlsx.

4. Read Chapter 12 in Spreadsheet Tools for Engineers Excel and

try all of the examples given. (Not Collected)

5. Solve each of the following systems of simultaneous equations

using matrices. Save the file as MATRIX1.xlsx.

(a)

2 3 7

3 2 0

2 3 17

1 2 3

1 2 3

1 2 3

x x x

x x x

x x x

(b)

0.2 0.4 0.2 1.2

0.2 0.1 0.4 3.6

0.5 2.5 0.4 4.7

0.1 0.5 2.7

1 2 3

1 2 3 4

1 2 3 4

1 2 4

x x x

x x x x

x x x x

x x x

(c)

2 5 3 13 92

4 4 10 20 0

3 2 7 15 0

4 2 15

11 3 2 51 0

1 2 3 4 5

1 3 4 5

1 2 3 4

2 3 5

1 2 4 5

x x x x x

x x x x

x x x x

x x x

x x x x

6. Solve the following systems of nonlinear algebraic equations in

Excel using Solver. Save the file as Solver.xlsx.

(a)

2 50

4 3 20

1

2

1 2

2

3

1

x x x

x x

(b)

ln cos3 2

sin 2 ln 0.3

2

2

1

1 1 2

x x

x x x

(c)

3ln sin cos 2

cos 2ln sin 3

sin cos ln 0

1 2 3

1 2 3

1 2 3

x x x

x x x

x x x