Computer Applications in Engineering

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