Engineering with Excel / Edition 5

by Ronald Larsen

Overview

This extensive book thoroughly covering the application of Excel to Engineering, includes many engineering-oriented examples and problems from a variety of disciplines. Covers Excel from the basics to its relation to financial calculation; matrix math; statistics; data fitting and interpolation; iterative methods; programming; integration & differentiation; and working with other programs. This book is suitable as a complete engineering reference to excel for those who want to learn to apply Excel to engineering problems.

Product Details

ISBN-13:	2900134589663
Publication date:	01/05/2017
Pages:	720
Product dimensions:	6.00(w) x 1.25(h) x 9.00(d)

About the Author

Ronald W. Larsen, Ph.D., P.E., is the Department Head of the Chemical and Biological Engineering Department at Montana State University.

Table of Contents

1	Introduction to Excel	1
1.1	Introduction	1
1.2	Starting Excel	4
1.3	A Little Windows	6
1.4	Spreadsheet Basics	10
1.5	Printing the Spreadsheet	32
1.6	Saving, Opening Workbooks, and Exiting	35
2	Graphing with Excel	46
2.1	Introduction	46
2.2	Getting Ready to Graph: Importing Text Files	47
2.3	Creating an XY Scatter Plot	50
2.4	Editing an Existing Graph	54
2.5	Creating Graphs with Multiple Curves	63
2.6	Printing the Graph	69
2.7	Types of Graphs	69
3	Excel Functions	84
3.1	Introduction to Excel Functions	84
3.2	Excel's Built-in Functions	85
3.3	Using the Convert ( ) Function to Convert Units	88
3.4	Simple Math Functions	92
3.5	Computing Sums	94
3.6	Trigonometric Functions	97
3.7	Inverse Trigonometric Functions	100
3.8	Advanced Math Functions	104
3.9	Conditional Formatting	106
3.10	Error Function	108
3.11	Bessel Functions	109
3.12	Working with Complex Numbers	110
3.13	Working with Binary, Octal, and Hexadecimal Values	110
3.14	Miscellaneous Functions	111
4	Matrix Operations in Excel	126
4.1	Matrix Manipulations: Vectors, Matrices, and Arrays	126
4.2	How Excel Handles Matrix Math	127
4.3	Basic Matrix Operations	127
4.4	Solving Systems of Linear Equations	137
5	Linear Regression in Excel	153
5.1	Introduction	153
5.2	Linear Regression Using Excel Functions	154
5.3	Linear Regression Using Excel's Trend Line Capability	156
5.4	Other Two-Coefficient Linear Regression Models	160
5.5	Polynomial Regression	162
5.6	Linear Regression Using Excel's Regression Analysis Package	164
6	Iterative Solutions Using Excel	187
6.1	Introduction	187
6.2	Iterative Solutions	188
6.3	Introduction to Excel's Solver	198
6.4	Optimization Using the Solver	204
6.5	Nonlinear Regression	208
6.6	Testing the Regression Result	213
7	Using Macros in Excel	225
7.1	Introduction	225
7.2	Macros and Viruses	227
7.3	Recorded Macros	227
7.4	Programmed Macros (VBA)	246
8	Programming in Excel with VBA	268
8.1	Introduction	268
8.2	Visual Basic for Applications (VBA) Overview	269
8.3	Forms and Modules	270
8.4	Working with Forms	278
8.5	Using the Form from the Spreadsheet	288
9	Sharing Excel Information with Other Programs	296
9.1	Introduction to Sharing Excel Information with Other Programs	296
9.2	Using Copy and Paste to Move Information	297
9.3	Embedded and Linked Objects	305
9.4	External Data Sources	319
10	Time Value of Money with Excel	335
10.1	Time, Money, and Cash Flows	335
10.2	Interest Rates and Compounding	338
10.3	Moving Amounts through Time	342
10.4	Economic Alternatives: Making Decisions	354
11	Financial Calculations with Excel	363
11.1	Introduction	363
11.2	Internal Rate of Return and Net Present Value	364
11.3	Depreciation of Assets	370
12	Excel's Statistics Functions	387
12.1	Overview	387
12.2	Populations and Samples	388
12.3	Standard Deviations and Variances	389
12.4	Errors, Deviations, and Distributions	392
12.5	Confidence Intervals	398
13	Numerical Differentiation Using Excel	409
13.1	Finite Differences	409
13.2	Filtering Data	417
13.3	Curve-Fitting and Differentiation	423
14	Numerical Integration Using Excel	433
14.1	Integrating for Area under a Curve	433
14.2	Integrating for Area Between Two Curves	434
14.3	Numerical Integration Methods	434
14.4	Using Regression Equations for Integration	447
15	Numerical Integration Techniques for Differential Equations Using Excel	459
15.1	Euler's Method	459
15.2	Fourth-Order Runge-Kutta Method	467
15.3	Integrating Two Simultaneous ODEs Using the Runge-Kutta Method	473
15.4	Implicit Methods	479
	Index	490

Preface

ESource–The Prentice Hall Engineering Source–
www.prenhall.com/esource

ESource—The Prentice Hall Engineering Source gives professors the power to harness the full potential of their text and their first-year engineering course. More than just a collection of books, ESource is a unique publishing system revolving around the ESource website— www.prenhall.com/esource. ESource enables you to put your stamp on your book just as you do your course. It lets you:

• Control: You choose exactly what chapter or sections are in your book and in what order they appear. Of course, you can choose the entire book if you'd like and stay with the authors' original order.
• Optimize: Get the most from your book and your course. ESource lets you produce the optimal text for your students needs.
• Customize: You can add your own material anywhere in your text's presentation, and your final product will arrive at your bookstore as a professionally formatted text. Of course, all titles in this series are available as stand-alone texts, or as bundles of two or more books sold at a discount. Contact your PH sales rep for discount information.

ESource ACCESS

Professors who choose to bundle two or more texts from the ESource series for their class, or use an ESource custom book will be providing their students with complete access to the library of ESource content. All bundles and custom books will come with a student password that gives web ESource ACCESS to all information on the site. This passcode is free and is valid for one yearafter initial logon. We've designed ESource ACCESS to provide students a flexible, searchable, on-line resource. Professors may also choose to deliver custom ESource content via the web only using ESource ACCESS passcodes. Contact your PH sales rep for more information.

ESource Content

All the content in ESource was written by educators specifically for freshman/first-year students. Authors tried to strike a balanced level of presentation, an approach that was neither formulaic nor trivial, and one that did not focus too heavily on advanced topics that most introductory students do not encounter until later classes. Because many professors do not have extensive time to cover these topics in the classroom, authors prepared each text with the idea that many students would use it for self-instruction and independent study Students should be able to use this content to learn the software tool or subject on their own.

While authors had the freedom to write texts in a style appropriate to their particular subject, all followed certain guidelines created to promote a consistency that makes students comfortable. Namely, every chapter opens with a clear set of Objectives, includes Practice Boxes throughout the chapter, and ends with a number of Problems, and a list of Key Terms. Applications Boxes are spread throughout the book with the intent of giving students a real-world perspective of engineering. Success Boxes provide the student with advice about college study skills, and help students avoid the common pitfalls of first-year students. In addition, this series contains an entire book titled Engineering Success by Peter Schiavone of the University of Alberta intended to expose students quickly to what it takes to be an engineering student.

Creating Your Book

Using ESource is simple. You preview the content either on-line or through examination copies of the books you can request on-line, from your PH sales rep, or by calling 1-800-526-0485. Create an on-line outline of the content you want, in the order you want, using ESource's simple interface. Either type or cut and paste your own material and insert it into the text flow. You can preview the overall organization of the text you've created at anytime (please note, since this preview is immediate, it comes unformatted.), then press another button and receive an order number for your own custom book. If you are not ready to order, do nothing—ESource will save your work. You can come back at any time and change, re-arrange, or add more material to your creation. Once you're finished and you have an ISBN, give it to your bookstore and your book will arrive on their shelves four to six weeks after they order. Your custom desk copies with their instructor supplements will arrive at your address at the same time.

To learn more about this new system for creating the perfect textbook, go to www.prenhall.com/esource. You can either go through the on-line walkthrough of how to create a book, or experiment yourself.

Supplements

Adopters of ESource receive an instructor's CD that contains professor and student code from the books in the series, as well as other instruction aides provided by authors. The website also holds approximately 350 PowerPoint transparencies created by Jack Leifer of University of Kentucky-Paducah available to download. Professors can either follow these transparencies as pre-prepared lectures or use them as the basis for their own custom presentations.

Editorial Reviews

This textbook for a first-year engineering course explains how to apply the Excel spreadsheet program to perform common engineering calculations. Topics include graphing, matrix operations, linear regression, macros, Visual Basic for applications, financial calculations, statistics functions, and numerical integration techniques for differential equations. Annotation c. Book News, Inc., Portland, OR (booknews.com)