BN.com Gift Guide

Excel Scientific and Engineering Cookbook

( 1 )

Overview

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...

See more details below
Other sellers (Paperback)
  • All (14) from $11.59   
  • New (9) from $25.49   
  • Used (5) from $11.59   
Excel Scientific and Engineering Cookbook

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780596008796
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 1/24/2006
  • Series: Cookbooks (O'Reilly) Series
  • Edition number: 1
  • Pages: 446
  • Product dimensions: 7.18 (w) x 9.07 (h) x 1.06 (d)

Meet 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.

Read More Show Less

Table of Contents

Preface

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

Colophon

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 19, 2006

    COOKING WITH SCIENCE AND ENGINEERING!!

    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.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)