Engineering Computations: An Introduction Using MATLAB and Excel

Cover Page......Page 1
Title Page......Page 2
Copyright Page......Page 3
Contents......Page 4
Preface......Page 6
Part 1 Computational Tools......Page 8
Introduction......Page 10
1.1 Analytic and Algorithmic Solutions......Page 11
1.2 Approaches to Engineering Computation......Page 18
1.3 Data Representation......Page 20
2.1 The Excel Interface......Page 28
2.2 Tutorial:Entering and Formatting Data with Excel......Page 31
2.3 Tutorial:Entering and Formatting Formulas with Excel......Page 37
2.4 Tutorial:Using Built-in Functions......Page 45
2.5 Tutorial:Performing Logical Tests Using the IF Statement......Page 50
2.6 Tutorial:Using Lookup Tables......Page 57
2.7 Tutorial:Interpolating with Excel......Page 61
3.1 The MATLAB Interface......Page 70
3.2 Tutorial:Using the Command Window for Interactive Computation......Page 71
3.3 Tutorial:Using MATLAB Script Files......Page 81
3.4 Tutorial:Using MATLAB Function Files......Page 89
3.5 Tutorial:Computing with One-Dimensional Arrays......Page 93
3.6 Tutorial:Computing with Two-Dimensional Arrays......Page 100
3.7 Tutorial:Saving a MATLAB Session......Page 105
4.1 Flowcharts......Page 112
4.2 Tutorial:Loop Commands......Page 115
4.3 Tutorial:Logical Branching Statements......Page 124
4.4 Tutorial:Combining Loops and Logic......Page 134
4.5 Tutorial:Formatting MATLAB Output......Page 139
5.1 Types of Graphs......Page 150
5.2 XY Graphs......Page 154
5.3 Guidelines for Producing Good Graphs......Page 185
5.4 Tutorial:Creating Other Types of Graphs with Excel......Page 187
Part 2 Engineering Applications......Page 202
Introduction......Page 204
6.1 Motivation......Page 205
6.2 Roots of Equations:Theory......Page 206
6.3 Tutorial:Solution of General Nonlinear Equations Using MATLAB......Page 216
6.4 Tutorial:Solution of Polynomial Equations Using MATLAB......Page 218
6.5 Tutorial:Solution of General Nonlinear Equations Using Excel......Page 221
7.1 Properties of Matrices......Page 228
7.2 Tutorial:Matrix Operations Using Excel......Page 232
7.3 Tutorial:Matrix Operations Using MATLAB......Page 237
8.1 Systems of Linear Equations......Page 246
8.2 Tutorial:Solutions of Linear Equations Using Excel......Page 247
8.3 Tutorial:Solutions to Simultaneous Linear Equations Using MATLAB......Page 254
8.4 Tutorial:Solving Nonlinear Simultaneous EquationsUsing Excel......Page 257
9.1 Concepts from Calculus......Page 266
9.2 Tutorial:Numerical Integration of Functions......Page 270
9.3 Tutorial:Numerical Integration of Measured Data......Page 283
Introduction......Page 294
10.1 Engineering Optimization......Page 295
10.2 Formulating an Optimization Problem......Page 297
10.3 Solution of an Optimization Problem......Page 299
10.4 Solution of an Optimization Problem Using MATLAB......Page 308
10.5 Solution of an Optimization Problem Using Excel......Page 315
10.6 Tutorial:Engineering Application of Linear Constrained Optimization......Page 324
Index......Page 334