Engineering Computations: An Introduction Using MATLAB and Excel Book

Preface v

Part 1

Chapter 1 Computing Tools 3

Introduction 3

1.1 Analytic and Algorithmic Solutions 4

1.2 Approaches to Engineering Computation 11

1.3 Data Representation 13

Chapter 2 Excel Fundamentals 21

Introduction 21

2.1 The Excel Interface 21

2.2 Tutorial: Entering and Formatting Data with Excel 24

2.3 Tutorial: Entering and Formatting Formulas with Excel 30

2.4 Tutorial: Using Built-in Functions 38

2.5 Tutorial: Performing Logical Tests Using the IF Statement 43

2.6 Tutorial: Using Lookup Tables 50

2.7 Tutorial: Interpolating with Excel 54

Chapter 3 MATLAB Fundamentals 63

Introduction 63

3.1 The MATLAB Interface 63

3.2 Tutorial: Using the Command Window for Interactive Computation 64

3.3 Tutorial: Using MATLAB Script Files 74

3.4 Tutorial: Using MATLAB Function Files 82

3.5 Tutorial: Computing With One-Dimensional Arrays 86

3.6 Tutorial: Computing With Two-Dimensional Arrays 93

3.7 Tutorial: Saving a MATLAB Session 98

Chapter 4 MATLAB Programming 105

Introduction 105

4.1 Flowcharts 105

4.2 Tutorial: Loop Commands 108

4.3 Tutorial: Logical Branching Statements 117

4.4 Tutorial: Combining Loops and Logic 127

4.5 Tutorial: Formating MATLAB Output 132

Chapter 5 Plotting Data 143

Introduction 143

5.1 Types of Graphs 143

5.2 XY Graphs 147

5.3 Guidelines for Producing Good Graphs 178

5.4 Tutorial: Creating Other Types of Graphs with Excel 180

Part 2

Chapter 6 Finding the Roots of Equations 197

Introduction 197

6.1 Motivation 198

6.2 Roots of Equations: Theory 199

6.3 Tutorial: Solution of General Nonlinear Equations Using MATLAB209

6.4 Tutorial: Solution of Polynomial Equations Using MATLAB 211

6.5 Tutorial: Solution of General Nonlinear Equations Using Excel 214

Chapter 7 Matrix Mathematics 221

Introduction 221

7.1 Properties of Matrices 221

7.2 Tutorial: Matrix Operations using Excel 225

7.3 Tutorial: Matrix Operations using MATLAB 230

Chapter 8 Solving Simultaneous Equations 239

Introduction 239

8.1 Systems of Linear Equations 239

8.2 Tutorial: Solutions of Linear Equations Using Excel 240

8.3 Tutorial: Solutions to Simultaneous Linear Equations Using MATLAB 247

8.4 Tutorial: Solving Nonlinear Simultaneous Equations Using Excel 250

Chapter 9 Numerical Integration 259

Introduction 259

9.1 Concepts from Calculus 259

9.2 Tutorial: Numerical Integration of Functions 263

9.3 Tutorial: Numerical Integration of Measured Data 276

Chapter 10 Optimization 287

Introduction 287

10.1 Engineering Optimization 288

10.2 Formulating an Optimization Problem 290

10.3 Solution of an Optimization Problem 292

10.4 Solution of an Optimization Problem Using MATLAB 301

10.5 Solution of an Optimization Problem Using Excel 308

10.6 Tutorial: Engineering Application of Linear Constrained Optimization 317

Index 327