Excel Scientific and Engineering Cookbook (Cookbooks (O'Reilly)) | 
| Author: David Bourg
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $44.99
Buy New: $25.68
You Save: $19.31 (43%)
New (29) Used (11) from $20.00
Avg. Customer Rating:  9 reviews
Sales Rank: 31765
Format: Illustrated
Media: Paperback
Number Of Items: 1
Pages: 442
Shipping Weight (lbs): 1.5
Dimensions (in): 9 x 7 x 1.2
ISBN: 0596008791
Dewey Decimal Number: 005.54
EAN: 9780596008796
ASIN: 0596008791
Publication Date: January 17, 2006
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand new item. Over 4 million customers served. Order now. Selling online since 1995. Few left in stock - order soon. Code: I20080924021124S
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: - Use Excel and VBA in general
- Import data from a variety of sources
- Analyze data
- Perform calculations
- Visualize the results for interpretation and presentation
- Use Excel to solve specific science and engineering problems
Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.
|
| Customer Reviews: Read 4 more reviews...
 PROBLEM SOLUTION DISCUSSION May 9, 2007
6 out of 15 found this review helpful
1.1 This Book
Problem
The entire book is written in this silly format.
Solution
If this sort of thing bothers you, buy something else
Discussion
This cloying and tiresome gimmick gets repeated throughout the entire book. Every time I pick it up, I feel like I'm listening to Donald Rumsfeld. There seems to be lots of good information about using Excel in scientific and engineering contexts, but the writing style is just too much for some of us. Whatever happened to straightforward narrative?
Excel Cookbook Half Baked May 9, 2007
2 out of 6 found this review helpful
It appears to be a good book but the writers style lacks substance. I could have written this book! I am not an expert on Excel but I have used it since the mid to late 1980's so I know a few things. The section on VBA was weak. I expected more but got less. Most Excel books are concentrated on Business Applications and I was hopeful to find one that actually had something to do with Engineering but it was too weak. No good examples, just pictures of spreadsheets and no formulas. Cut and pasting function names is lame!
 an alternative point of view January 2, 2007
6 out of 29 found this review helpful
Be wary of using other programmer's work unless it has passed the
sort of critical tests as available on the NIST site.
A number of techniques in EXCEL are not useful for various
problems in the sciences. There are also problems inherent
in digital computation, regardless of language or platform,
which can result in serious errors. If you are doing serious
work, you should make the investment in the hardware and
software which can pass rigorous examination.
 COOKING WITH SCIENCE AND ENGINEERING!! August 19, 2006
9 out of 11 found this review helpful
Do you have scientific or engineering calculations to perform? If you do, then this book is for you! Author David M Bourg, has done an outstanding job of writing a book that shows you how to leverage Excel as a capable computing tool to solve a variety of both routine and complex problems.
Bourg, begins by covering a variety of fundamental topics, including navigating Excel's interface, entering data and formulas, and formatting cells. Then, the author covers a variety of fundamental VBA programming topics, including VBA syntax, using the VBA editor, and integrating VBA code with Excel spreadsheets. Next, he shows you how to import data into Excel from a variety of sources, including text files, databases, and the Web. The author then shows you how to visualize data in Excel. He continues by showing you how to perform standard statistical calculations in Excel, such as computing summary statistics, calculating confidence intervals, and performing analysis of variance, among other calculations. Then, the author shows you how to conduct various time series analysis tasks, including forecasting and Fourier transforms in Excel. Next, he introduces you to many of Excel's useful math functions. The author continues the discussion of data analysis, specifically focusing on curve fitting and regression analysis. Then, the author shows you how to leverage Excel to solve linear and nonlinear equations, as well as linear and nonlinear systems. Next, he shows you how to perform various numerical integration calculations, such as computing areas and moments of areas, among others. The author then shows you how to solve initial value and boundary value problems using standard numerical techniques such as the Runge-Kutta and shooting methods. He continues by showing you how to leverage Excel to help solve problems involving partial differential equations. Then, the author shows you how to perform optimization analysis using Excel's built-in optimization tools. Finally, he introduces you to some of Excel's extensive financial analysis capabilities.
This most excellent book aims to present Excel as a cradle to the grave computing environment for scientific and engineering computations. More importantly, this book shows you how to use Excel and VBA in general, how to import data from a variety of sources, analyze data, perform calculations, and finally visualize the results for interpretation and presentation.
Excellent all-purpose collection of analytical recipes July 30, 2006
2 out of 4 found this review helpful
Bourg's book is an excellent collection of analytical recipes suitable for undergraduates, graduate and postdocs in all scientific disciplines. Engineers will find good treatment of important topics such as optimization and numerical integration. Statistical anlysis is also covered, although no theoritical background is provided, and in this format, none should be expected, as the author indicates. An excellent and useful book.
|
|
|
