Excel Scientific and Engineering Cookbook Adding Excel to Your Analysis Arsenal

Name: Excel Scientific and Engineering Cookbook Adding Excel to Your Analysis Arsenal
Availability: InStock
ISBN: 9780596008796

ISBN-10: 0596008791

ISBN-13: 9780596008796

Edition: 2006

Authors: David M. Bourg

List price: $49.99

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $7.45

Buy new: $34.66

Marketplace

4 new & used from $4.01

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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…

Book details

List price: $49.99
Copyright year: 2006
Publisher: O'Reilly Media, Incorporated
Publication date: 2/7/2006
Binding: Paperback
Pages: 442
Size: 6.75" wide x 8.75" long x 1.00" tall
Weight: 1.540
Language: English

David Bourg is a Naval Architect involved in various military and commercial proposal, design, and construction efforts. Since 1998, David has served as an independent consultant working for various regional clients engaged in both commercial and military shipbuilding where he provides design and analysis services including but not limited to concept design, proposal writing, detailed design and analysis, visualization, and software development among other services. He coordinated and led the winning design and proposal effort for the US Coast Guard Point Class (patrol boat) Replacement Program. In 2006, David joined fellow Naval Architect Kenneth Humphreys to form MiNO Marine, LLC, a naval…



Preface



Using Excel



Navigating the Interface



Entering Data



Setting Cell Data Types



Selecting More Than a Single Cell



Entering Formulas



Exploring the R1C1 Cell Reference Style



Referring to More Than a Single Cell



Understanding Operator Precedence



Using Exponents in Formulas



Exploring Functions



Formatting Your Spreadsheets



Defining Custom Format Styles



Leveraging Copy, Cut, Paste, and Paste Special



Using Cell Names (Like Programming Variables)



Validating Data



Taking Advantage of Macros



Adding Comments and Equation Notes



Getting Help



Getting Acquainted with Visual Basic for Applications



Navigating the VBA Editor



Writing Functions and Subroutines



Working with Data Types



Defining Variables



Defining Constants



Using Arrays



Commenting Code



Spanning Long Statements over Multiple Lines



Using Conditional Statements



Using Loops



Debugging VBA Code



Exploring VBA's Built-in Functions



Exploring Excel Objects



Creating Your Own Objects in VBA



VBA Help



Collecting and Cleaning Up Data



Importing Data from Text Files



Importing Data from Delimited Text Files



Importing Data Using Drag-and-Drop



Importing Data from Access Databases



Importing Data from Web Pages



Parsing Data



Removing Weird Characters from Imported Text



Converting Units



Sorting Data



Filtering Data



Looking Up Values in Tables



Retrieving Data from XML Files



Charting



Creating Simple Charts



Exploring Chart Styles



Formatting Charts



Customizing Chart Axes



Setting Log or Semilog Scales



Using Multiple Axes



Changing the Type of an Existing Chart



Combining Chart Types



Building 3D Surface Plots



Preparting Contour Plots



Annotating Charts



Saving Custom Chart Types



Copying Charts to Word



Displaying Error Bars



Statistical Analysis



Computing Summary Statistics



Plotting Frequency Distributions



Calculating Confidence Intervals



Correlating Data



Ranking and Percentiles



Performing Statistical Tests



Conducting ANOVA



Generating Random Numbers



Sampling Data



Time Series Analysis



Plotting Time Series Data



Adding Trendlines



Computing Moving Averages



Smoothing Data Using Weighted Averages



Centering Data



Detrending a Time Series



Estimating Seasonal Indices



Deseasonalization of a Time Series



Forecasting



Applying Discrete Fourier Transforms



Mathematical Functions



Using Summation Functions



Delving into Division



Mastering Multiplication



Exploring Exponential and Logarithmic Functions



Using Trigonometry Functions



Seeing Signs



Getting to the Root of Things



Rounding and Truncating Numbers



Converting Between Number Systems



Manipulating Matrices



Building Support for Vectors



Using Spreadsheet Functions in VBA Code



Dealing with Complex Numbers



Curve Fitting and Regression



Performing Linear Curve Fitting Using Excel Charts



Constructing Your Own Linear Fit Using Spreadsheet Functions



Using a Single Spreadsheet Function for Linear Curve Fitting



Performing Multiple Linear Regression



Generating Nonlinear Curve Fits Using Excel Charts



Fitting Nonlinear Curves Using Solver



Assessing Goodness of Fit



Computing Confidence Intervals



Solving Equations



Finding Roots Graphically



Solving Nonlinear Equations Iteratively



Automating Tedious Problems with VBA



Solving Linear Systems



Tackling Nonlinear Systems of Equations



Using Classical Methods for Solving Equations



Numerical Integration and Differentiation



Integrating a Definite Integral



Implementing the Trapezoidal Rule in VBA



Computing the Center of an Area Using Numerical Integration



Calculating the Second Moment of an Area



Dealing with Double Integrals



Numerical Differentiation



Solving Ordinary Differential Equations



Solving First-Order Initial Value Problems



Applying the Runge-Kutta Method to Second-Order Initial Value Problems



Tackling Coupled Equations



Shooting Boundary Value Problems



Solving Partial Differential Equations



Leveraging Excel to Directly Solve Finite Difference Equations



Recruiting Solver to Iteratively Solve Finite Difference Equations



Solving Initial Value Problems



Using Excel to Help Solve Problems Formulated Using the Finite Element Method



Performing Optimization Analyses in Excel



Using Excel for Traditional Linear Programming



Exploring Resource Allocation Optimization Problems



Getting More Realistic Results with Integer Constraints



Tackling Troublesome Problems



Optimizing Engineering Design Problems



Understanding Solver Reports



Programming a Genetic Algorithm for Optimization



Introduction to Financial Calculations



Computing Present Value



Calculating Future Value



Figuring Out Required Rate of Return



Doubling Your Money



Determining Monthly Payments



Considering Cash Flow Alternatives



Achieving a Certain Future Value



Assessing Net Present Worth



Estimating Rate of Return



Solving Inverse Problems



Figuring a Break-Even Point


Index