# Engineering with Excel / Edition 1

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)

## Related Subjects

 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

## Customer Reviews

Average Review:

Write a Review

and post it to your social network