Scientific Computing, Spreadsheets, Engineering & Computer Technology, Microsoft Excel

Excel for Scientists and Engineers

Name: Excel for Scientists and Engineers
Author: William J. Orvis
ISBN: 9780782117615

by William J. Orvis

Write a review

Overview

Excel for Scientists and Engineers is an essential sourcebook for implementing advanced numerical methods supplied in Excel for Windows 95 and Excel 5 for Windows 3.1 and Mac. Use Excel to perform all levels of numerical analysis. Each detailed example explains the numerical method used and how to implement it in Excel. You'll learn to prepare single-input and multi-input engineering tables, and create function calculators for painless "what-if" analysis; use Excel's built-in curve-fitting functions, from linear curve-fitting to linear regression, polynomial regression, and non-linear curve-fitting; employ popular integration functions, including the rectangle rule, the trapezoid rule, Simpson's rule, and Gaussian quadratures; use Excel's new distribution and statistical functions, plus Bessel, error, and delta functions; solve ordinary differential equations and partial differential equations by combining Excel's features in new ways; and create your own functions with Visual Basic for Applications.

Practicing scientists and engineers are already using spreadsheets to perform calculations, but they need a book like this to learn how to implement all the common numerical methods on a worksheet. While they could probably work them out on their own, the methods and worked-through examples in this book make it significantly easier. The disk includes all the examples in the book.