Pub. Date:
McGraw-Hill Companies, The
Spreadsheet Tools for Engineers: Excel / Edition 1

Spreadsheet Tools for Engineers: Excel / Edition 1

by Byron S. Gottfried


Current price is , Original price is $73.75. You

Temporarily Out of Stock Online

Please check back later for updated availability.

This item is available online through Marketplace sellers.


This best-selling Spreadsheet book provides excellent coverage of all versions of Excel including the latest version, Excel 2002. It discusses how to use Excel to solve a variety of problems in introductory engineering analysis, such as graphing data, unit conversions, simple statistical analysis, sorting, searching and analyzing data, curve fitting, interpolation, solving algebraic equations, logical decisions, evaluating integrals, comparing economic alternatives, and finding optimum solutions. Numerous examples are included illustrating both traditional and spreadsheet solutions to a variety of problems. The underlying mathematical solution procedures are also discussed, so that the reader is provided with an understanding of what the spreadsheet does and how it does it.

If you are an instructor who has adopted the book and would like access to the additional resources, please contact your local sales rep. or Michelle Flomenhoft at:

Product Details

ISBN-13: 9780072480689
Publisher: McGraw-Hill Companies, The
Publication date: 07/28/2002
Series: McGraw-Hill's Best Ser.: Basic Engineering Series and Tools
Edition description: Older Edition
Pages: 480
Product dimensions: 7.30(w) x 9.10(h) x 0.70(d)

About the Author

Byron S. Gottfried is a Professor of Industrial Engineering and Academic Director of the Freshman Engineering Program at the University of Pittsburgh. He has written eleven college textbooks, including Schaum's Outline of Programming with Basic.

Table of Contents

Chapter 1Engineering Analysis and Spreadsheets1
1.1General Problem-Solving Techniques1
1.2Applicable Engineering Fundamentals3
1.3Mathematical Solution Procedures5
1.4The Role of Spreadsheets7
Additional Reading12
Chapter 2Excel Fundamentals13
2.1Entering and Leaving Excel14
2.2Moving around the Worksheet22
2.3Entering Data24
2.4Correcting Errors27
2.5Using Formulas28
2.6Using Functions38
2.7Editing the Worksheet42
2.8Saving and Retrieving the Worksheet61
2.9Printing the Worksheet61
2.10Displaying Cell Formulas64
2.11Recording and Running Macros65
2.12Closing Remarks70
Additional Reading70
Chapter 3Graphing Data71
3.1Creating a Graph in Excel71
3.2Bar Graphs (Excel Column Charts)73
3.3Line Graphs (Excel Line Charts)80
3.4X-Y Graphs (Excel XY Charts, or Scatter Charts)84
3.5Semi-Log Graphs93
3.6Log-Log Graphs98
3.7Pie Charts104
3.8Closing Remarks110
Additional Reading110
Chapter 4Converting Units111
4.1Simple Conversions111
4.2Simple Conversions in Excel112
4.3Complex Conversions116
4.4Complex Conversions in Excel117
Additional Reading121
Chapter 5Transferring Data122
5.1Importing Data from a Text File122
5.2Exporting Data to a Text File128
5.3Transferring HTML Data134
5.4Transferring a Worksheet to Microsoft Word137
5.5Transferring a Worksheet to Microsoft PowerPoint142
Additional Reading147
Chapter 6Analyzing Data148
6.1Data Characteristics148
6.3Cumulative Distributions163
Additional Reading171
Chapter 7Organizing Data173
7.1Creating a List in Excel174
7.2Sorting Data in Excel177
7.3Retrieving (Filtering) Data in Excel180
7.4Pivot Tables187
Additional Reading197
Chapter 8Fitting Equations to Data198
8.1The Method of Least Squares199
8.2Fitting a Straight Line to a Set of Data200
8.3Derivation of the Least Squares Equations213
8.4Fitting Other Functions to a Set of Data214
8.5Selecting the Best Function for a Given Data Set229
Additional Reading246
Chapter 9Interpolating between Data Points247
9.1Linear Interpolation248
9.2Polynomial Interpolation Using Forward Differences254
9.3Polynomial Interpolation Using Backward Differences262
9.4Other Interpolation Techniques268
Additional Reading272
Chapter 10Solving Single Equations273
10.1Characteristics of Nonlinear Algebraic Equations274
10.2Graphical Solutions276
10.3Solving Equations in Excel Using Goal Seek278
10.4Solving Equations in Excel Using Solver281
10.5Interval-Reduction Techniques290
10.6Iterative Techniques293
Additional Reading297
Chapter 11Solving Simultaneous Equations298
11.1Matrix Notation299
11.2Matrix Operations in Excel309
11.3Solving Simultaneous Equations in Excel Using Matrix Inversion311
11.4Solving Simultaneous Equations in Excel Using Solver315
Additional Reading330
Chapter 12Making Logical Decisions (IF-THEN-ELSE)331
12.1Logical Expressions331
12.2The IF Function332
12.3Nested IF Functions332
Additional Reading339
Chapter 13Evaluating Integrals340
13.1The Trapezoidal Rule341
13.2Simpson's Rule354
Additional Reading365
Chapter 14Comparing Economic Alternatives366
14.1Compound Interest366
14.2The Time Value of Money378
14.3Uniform, Multipayment Cash Flows381
14.4Irregular Cash Flows389
14.5Internal Rate of Return397
Additional Reading404
Chapter 15Finding Optimum Solutions406
15.1Optimization Problem Characteristics407
15.2Solving Optimization Problems in Excel419
Additional Reading436
Answers to Selected Problems438

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews