Engineering with Excel / Edition 1

Engineering with Excel / Edition 1

by Ronald W. Larsen
     
 

ISBN-10: 0130176966

ISBN-13: 9780130176967

Pub. Date: 01/28/2002

Publisher: Pearson Education

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

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:
9780130176967
Publisher:
Pearson Education
Publication date:
01/28/2002
Edition description:
Older Edition
Pages:
492
Product dimensions:
7.01(w) x 9.25(h) x 0.28(d)

Table of Contents

1Introduction to Excel1
1.1Introduction1
1.2Starting Excel4
1.3A Little Windows6
1.4Spreadsheet Basics10
1.5Printing the Spreadsheet32
1.6Saving, Opening Workbooks, and Exiting35
2Graphing with Excel46
2.1Introduction46
2.2Getting Ready to Graph: Importing Text Files47
2.3Creating an XY Scatter Plot50
2.4Editing an Existing Graph54
2.5Creating Graphs with Multiple Curves63
2.6Printing the Graph69
2.7Types of Graphs69
3Excel Functions84
3.1Introduction to Excel Functions84
3.2Excel's Built-in Functions85
3.3Using the Convert ( ) Function to Convert Units88
3.4Simple Math Functions92
3.5Computing Sums94
3.6Trigonometric Functions97
3.7Inverse Trigonometric Functions100
3.8Advanced Math Functions104
3.9Conditional Formatting106
3.10Error Function108
3.11Bessel Functions109
3.12Working with Complex Numbers110
3.13Working with Binary, Octal, and Hexadecimal Values110
3.14Miscellaneous Functions111
4Matrix Operations in Excel126
4.1Matrix Manipulations: Vectors, Matrices, and Arrays126
4.2How Excel Handles Matrix Math127
4.3Basic Matrix Operations127
4.4Solving Systems of Linear Equations137
5Linear Regression in Excel153
5.1Introduction153
5.2Linear Regression Using Excel Functions154
5.3Linear Regression Using Excel's Trend Line Capability156
5.4Other Two-Coefficient Linear Regression Models160
5.5Polynomial Regression162
5.6Linear Regression Using Excel's Regression Analysis Package164
6Iterative Solutions Using Excel187
6.1Introduction187
6.2Iterative Solutions188
6.3Introduction to Excel's Solver198
6.4Optimization Using the Solver204
6.5Nonlinear Regression208
6.6Testing the Regression Result213
7Using Macros in Excel225
7.1Introduction225
7.2Macros and Viruses227
7.3Recorded Macros227
7.4Programmed Macros (VBA)246
8Programming in Excel with VBA268
8.1Introduction268
8.2Visual Basic for Applications (VBA) Overview269
8.3Forms and Modules270
8.4Working with Forms278
8.5Using the Form from the Spreadsheet288
9Sharing Excel Information with Other Programs296
9.1Introduction to Sharing Excel Information with Other Programs296
9.2Using Copy and Paste to Move Information297
9.3Embedded and Linked Objects305
9.4External Data Sources319
10Time Value of Money with Excel335
10.1Time, Money, and Cash Flows335
10.2Interest Rates and Compounding338
10.3Moving Amounts through Time342
10.4Economic Alternatives: Making Decisions354
11Financial Calculations with Excel363
11.1Introduction363
11.2Internal Rate of Return and Net Present Value364
11.3Depreciation of Assets370
12Excel's Statistics Functions387
12.1Overview387
12.2Populations and Samples388
12.3Standard Deviations and Variances389
12.4Errors, Deviations, and Distributions392
12.5Confidence Intervals398
13Numerical Differentiation Using Excel409
13.1Finite Differences409
13.2Filtering Data417
13.3Curve-Fitting and Differentiation423
14Numerical Integration Using Excel433
14.1Integrating for Area under a Curve433
14.2Integrating for Area Between Two Curves434
14.3Numerical Integration Methods434
14.4Using Regression Equations for Integration447
15Numerical Integration Techniques for Differential Equations Using Excel459
15.1Euler's Method459
15.2Fourth-Order Runge-Kutta Method467
15.3Integrating Two Simultaneous ODEs Using the Runge-Kutta Method473
15.4Implicit Methods479
Index490

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >