Excel for Scientists and Engineers [With Disk]

by William J. Orvis

Book 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... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0782117619
• ISBN13: 9780782117615
• Release Date: January 1995
• Publisher: Sybex
• Length: 547 Pages
• Weight: 2.25 lbs.
• Dimensions: 1.4" x 7.5" x 9.0"

Customer Reviews

There still is no better for science and engineering applications

This is THE book for teaching or learning how to apply Excel to science and engineering problems. I have tried them all in teaching courses over the past 10 years. None are as clear, authoritative, or instructive. The book is 10 years old. I will again use it for a course this Spring (2007), but the thread connecting it to current Excel reality is getting stretched thin. Please, please, please write a revsion !!!

Unveiling the Power of EXCEL in a Easy Manner

This book is one of a kind. Scientists, engineers and students in the field are already using Excel for data analysis yet Orvis' sourcebook provides a one-flip reference to all the implemented functions of Excel. The second edition features illustration of built-in science and engineering tools and covers Excel for Window 95, Windows 3.1, and Mac. Reader will learn not only how to calculate and plot simple equations but how to perform curve fitting; calculate statistics, numerical derivatives, and integrals; access external databases; and solve systems of equations and one- and two-dimensional differential equations. The book also explains how to create graphics and how to use the built-in Visual Basic for Applications programming language to extend the capabilities of the Excel worksheets. Orvis himself is a scientist. The book is based on real uses of a spreadsheet as an engineering tool. Many of the problems were actually solved by Orvis using other techniques before he realized the full potential of the Excel spreadsheets. Therefore the book itself helps solve real problems, not just a textbook problems. This proves to be very helpful for those working in the lab and work on data analysis.The book assume basic working knowledge with Excel; such as moving around the cells and inserting data. It assumes basic undergrad math. This is highly recommended for scientists and engineers.

A totally different order of Excel book! Still very current.

I've owned copies of both editions of William Orvis's wonderful book and if he revises it again, I'll be first in line for a copy of the third edition. He begins with a general overview of Excel as a scientific and engineering calculation and graphing tool, assuming very little knowledge of Excel and only basic undergrad math skills. It's no book for "dummies," but anyone of reasonable intelligence and clarity of mind will have no difficulty in following what he says here. There are lots of well-explained examples, and the CD which comes with the book makes it easy to reproduce them without laborious data entry. Then he gives a brief survey of Visual Basic for Applications (VBA) -- VBA light, but enough to do many useful things. Next come chapters on data base functions, curve fitting, and series models. After a chapter on numerical differentiation and integration in general, the author deals with techniques for finding roots of nonlinear equations, solving sets of linear and nonlinear equations, and integrating ordinary and partial differential equations. While the book is oriented toward Excel 7 for Win 95, no one is likely to find it at all difficult to apply what it says directly in working with later versions or those running under other OSs. There are lots of topics I'd like to see added, or treated in greater depth, but the author could scarcely have covered more in a single 500-page book, and I have no quarrel with the balance he has chosen. None of the other science- or engineering-oriented Excel books even approach this one in value and coverage -- I've read them all. Excel is no substitute for Mathematica or even MathCad, but this book gave me an entirely different appreciation for the strengths it does offer for analyzing data. This is a book I recommend not only to engineers and "hard" scientists but to anyone with a need for rigorous data analysis.

Really gives insight on the power and flexibility of Excel.

Never realized what a powerful analytical tool I had with Excel! The author does a great job of teaching the reader who follows the examples and exercises hands-on. And I've only worked examples througth to the 4th chapter! Very recommendable for anyone doing number crunching and engaged in "what-if?" scenario analysis.

GREAT book!!!

This book covers subjects thoroughly. Spending less than 15 minutes with this book answered a question I have researched for over a year. After reading this book, I now have a better understanding of how Excel can help me in many mathematical as well as real-life situations. The author clearly details the steps needed for each application.