Engineering Computation: An Introduction Using MATLAB and Excel

by Musto, Joseph; Howard, William; Williams, Richard

• ISBN13: 9780073380162
• ISBN10: 0073380164
• Edition: 1st
• Format: Paperback
• Copyright: 2008-10-01
• Publisher: McGraw-Hill Education

Summary

The strength of the Engineering Computations text is its combination of the two most important computational programs in the engineering marketplace today, MATLAB and Excel. Engineering students will need to know how to use both programs to solve problems. Howard/Musto/Williams introductory text, Engineering Computations provides an introduction to both programs.While it is important to teach the mechanics of using the relevant tools, those tools can change so the focus of this text is on thefundamentals of engineering computing: algorithm development, selection of appropriate tools, documentation of solutions, and verification and interpretation of results.This is a new project that will be in a growth phase for the next few editions. Engineering schools continue to struggle with where to fit a computer methods course and Musto/Howard/Williams meets the need for a brief low level introduction to these programs.This book fits into the BEST series and will allow professors to use one book where they used to need two.

Table of Contents

Preface	p. v
Computing Tools	p. 3
Introduction	p. 3
Analytic and Algorithmic Solutions	p. 4
Approaches to Engineering Computation	p. 11
Data Representation	p. 13
Excel Fundamentals	p. 21
Introduction	p. 21
The Excel Interface	p. 21
Tutorial: Entering and Formatting Data with Excel	p. 24
Tutorial: Entering and Formatting Formulas with Excel	p. 30
Tutorial: Using Built-in Functions	p. 38
Tutorial: Performing Logical Tests Using the IF Statement	p. 43
Tutorial: Using Lookup Tables	p. 50
Tutorial: Interpolating with Excel	p. 54
MATLAB Fundamentals	p. 63
Introduction	p. 63
The MATLAB Interface	p. 63
Tutorial: Using the Command Window for Interactive Computation	p. 64
Tutorial: Using MATLAB Script Files	p. 74
Tutorial: Using MATLAB Function Files	p. 82
Tutorial: Computing With One-Dimensional Arrays	p. 86
Tutorial: Computing With Two-Dimensional Arrays	p. 93
Tutorial: Saving a MATLAB Session	p. 98
MATLAB Programming	p. 105
Introduction	p. 105
Flowcharts	p. 105
Tutorial: Loop Commands	p. 108
Tutorial: Logical Branching Statements	p. 117
Tutorial: Combining Loops and Logic	p. 127
Tutorial: Formating MATLAB Output	p. 132
Plotting Data	p. 143
Introduction	p. 143
Types of Graphs	p. 143
XY Graphs	p. 147
Guidelines for Producing Good Graphs	p. 178
Tutorial: Creating Other Types of Graphs with Excel	p. 180
Finding the Roots of Equations	p. 197
Introduction	p. 197
Motivation	p. 198
Roots of Equations: Theory	p. 199
Tutorial: Solution of General Nonlinear Equations Using MATLAB	p. 209
Tutorial: Solution of Polynomial Equations Using MATLAB	p. 211
Tutorial: Solution of General Nonlinear Equations Using Excel	p. 214
Matrix Mathematics	p. 221
Introduction	p. 221
Properties of Matrices	p. 221
Tutorial: Matrix Operations using Excel	p. 225
Tutorial: Matrix Operations using MATLAB	p. 230
Solving Simultaneous Equations	p. 239
Introduction	p. 239
Systems of Linear Equations	p. 239
Tutorial: Solutions of Linear Equations Using Excel	p. 240
Tutorial: Solutions to Simultaneous Linear Equations Using MATLAB	p. 247
Tutorial: Solving Nonlinear Simultaneous Equations Using Excel	p. 250
Numerical Integration	p. 259
Introduction	p. 259
Concepts from Calculus	p. 259
Tutorial: Numerical Integration of Functions	p. 263
Tutorial: Numerical Integration of Measured Data	p. 276
Optimization	p. 287
Introduction	p. 287
Engineering Optimization	p. 288
Formulating an Optimization Problem	p. 290
Solution of an Optimization Problem	p. 292
Solution of an Optimization Problem Using MATLAB	p. 301
Solution of an Optimization Problem Using Excel	p. 308
Tutorial: Engineering Application of Linear Constrained Optimization	p. 317
Index	p. 327
Table of Contents provided by Ingram. All Rights Reserved.