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.
About the Author
As a naval architect and marine engineer, David M. Bourg performs computer simulations and develops analysis tools that measure such things as hovercraft performance and the effect of waves on the motion of ships and boats. He teaches at the college level in the areas of ship design, construction and analysis. On occasion, David also lectures at high schools on topics such as naval architecture and software development. In addition to David's practical engineering background, he's professionally involved in computer game development and consulting through his company, Crescent Vision Interactive.
Table of Contents
- Chapter 1: Using Excel
- Chapter 2: Getting Acquainted with Visual Basic for Applications
- Chapter 3: Collecting and Cleaning Up Data
- Chapter 4: Charting
- Chapter 5: Statistical Analysis
- Chapter 6: Time Series Analysis
- Chapter 7: Mathematical Functions
- Chapter 8: Curve Fitting and Regression
- Chapter 9: Solving Equations
- Chapter 10: Numerical Integration and Differentiation
- Chapter 11: Solving Ordinary Differential Equations
- Chapter 12: Solving Partial Differential Equations
- Chapter 13: Performing Optimization Analyses in Excel
- Chapter 14: Introduction to Financial Calculations
Most Helpful Customer Reviews
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.