Excel Scientific and Engineering Cookbook

Name: Excel Scientific and Engineering Cookbook | Adding Excel to Your Analysis Arsenal
Brand: O'Reilly
Price: 70.69 EUR
Availability: OnlineOnly

Adding Excel to Your Analysis Arsenal

David M. Bourg(Autor*in)

O'Reilly (Verlag)

1. Auflage

Erschienen am 17. Januar 2006

446 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-0-596-55317-3 (ISBN)

70,69 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Intro
Excel Scientific and Engineering Cookbook
SPECIAL OFFER: Upgrade this ebook with O'Reilly
A Note Regarding Supplemental Files
Preface
1. Who Should Read This Book
2. What's in This Book
3. Conventions in This Book
4. Using Code Examples
5. Safari Enabled
6. We'd Like Your Feedback!
7. Acknowledgments
1. Using Excel
1.0. Introduction
1.1. Navigating the Interface
Problem
Solution
Discussion
Main menu bar
Task pane
Toolbars
See Also
1.2. Entering Data
Problem
Solution
Discussion
1.3. Setting Cell Data Types
Problem
Solution
Discussion
See Also
1.4. Selecting More Than a Single Cell
Problem
Solution
Discussion
See Also
1.5. Entering Formulas
Problem
Solution
Discussion
See Also
1.6. Exploring the R1C1 Cell Reference Style
Problem
Solution
Discussion
See Also
1.7. Referring to More Than a Single Cell
Problem
Solution
Discussion
See Also
1.8. Understanding Operator Precedence
Problem
Solution
Discussion
1.9. Using Exponents in Formulas
Problem
Solution
Discussion
See Also
1.10. Exploring Functions
Problem
Solution
Discussion
See Also
1.11. Formatting Your Spreadsheets
Problem
Solution
Discussion
See Also
1.12. Defining Custom Format Styles
Problem
Solution
Discussion
1.13. Leveraging Copy, Cut, Paste, and Paste Special
Problem
Solution
Discussion
1.14. Using Cell Names (Like Programming Variables)
Problem
Solution
Discussion
1.15. Validating Data
Problem
Solution
Discussion
1.16. Taking Advantage of Macros
Problem
Solution
Discussion
See Also
1.17. Adding Comments and Equation Notes
Problem
Solution
Discussion
See Also
1.18. Getting Help
Problem
Solution
2. Getting Acquainted with Visual Basic for Applications
2.0. Introduction
2.1. Navigating the VBA Editor
Problem
Solution
Discussion
See Also
2.2. Writing Functions and Subroutines
Problem
Solution
Discussion
Subroutines
Functions
2.3. Working with Data Types
Problem
Solution
Discussion
2.4. Defining Variables
Problem
Solution
Discussion
2.5. Defining Constants
Problem
Solution
Discussion
2.6. Using Arrays
Problem
Solution
Discussion
See Also
2.7. Commenting Code
Problem
Solution
2.8. Spanning Long Statements over Multiple Lines
Problem
Solution
2.9. Using Conditional Statements
Problem
Solution
See Also
2.10. Using Loops
Problem
Solution
Discussion
See Also
2.11. Debugging VBA Code
Problem
Solution
Discussion
2.12. Exploring VBA's Built-in Functions
Problem
Solution
Discussion
2.13. Exploring Excel Objects
Problem
Solution
Discussion
The Object Browser
Application object
Workbook object
Worksheet object
WorksheetFunction object
Range objects
See Also
2.14. Creating Your Own Objects in VBA
Problem
Solution
Discussion
See Also
2.15. VBA Help
Problem
Solution
3. Collecting and Cleaning Up Data
3.0. Introduction
3.1. Importing Data from Text Files
Problem
Solution
Discussion
See Also
3.2. Importing Data from Delimited Text Files
Problem
Solution
Discussion
See Also
3.3. Importing Data Using Drag-and-Drop
Problem
Solution
Discussion
See Also
3.4. Importing Data from Access Databases
Problem
Solution
Discussion
See Also
3.5. Importing Data from Web Pages
Problem
Solution
Discussion
See Also
3.6. Parsing Data
Problem
Solution
Discussion
3.7. Removing Weird Characters from Imported Text
Problem
Solution
Discussion
3.8. Converting Units
Problem
Solution
Discussion
Using CONVERT
Writing your own functions
Creating an add-in
3.9. Sorting Data
Problem
Solution
Discussion
See Also
3.10. Filtering Data
Problem
Solution
Discussion
See Also
3.11. Looking Up Values in Tables
Problem
Solution
Discussion
LOOKUP
VLOOKUP
HLOOKUP
MATCH
INDEX
See Also
3.12. Retrieving Data from XML Files
Problem
Solution
Discussion
See Also
4. Charting
4.0. Introduction
4.1. Creating Simple Charts
Problem
Solution
Discussion
See Also
4.2. Exploring Chart Styles
Problem
Solution
See Also
4.3. Formatting Charts
Problem
Solution
Discussion
4.4. Customizing Chart Axes
Problem
Solution
Discussion
4.5. Setting Log or Semilog Scales
Problem
Solution
Discussion
See Also
4.6. Using Multiple Axes
Problem
Solution
Discussion
4.7. Changing the Type of an Existing Chart
Problem
Solution
Discussion
4.8. Combining Chart Types
Problem
Solution
Discussion
4.9. Building 3D Surface Plots
Problem
Solution
Discussion
4.10. Preparing Contour Plots
Problem
Solution
Discussion
4.11. Annotating Charts
Problem
Solution
Discussion
See Also
4.12. Saving Custom Chart Types
Problem
Solution
4.13. Copying Charts to Word
Problem
Solution
Discussion
4-14. Displaying Error Bars
Problem
Solution
5. Statistical Analysis
5.0. Introduction
5.1. Computing Summary Statistics
Problem
Solution
Discussion
See Also
5.2. Plotting Frequency Distributions
Problem
Solution
Discussion
See Also
5.3. Calculating Confidence Intervals
Problem
Solution
Discussion
See Also
5.4. Correlating Data
Problem
Solution
Discussion
See Also
5.5. Ranking and Percentiles
Problem
Solution
Discussion
5.6. Performing Statistical Tests
Problem
Solution
Discussion
See Also
5.7. Conducting ANOVA
Problem
Solution
Discussion
See Also
5.8. Generating Random Numbers
Problem
Solution
Discussion
See Also
5.9. Sampling Data
Problem
Solution
Discussion
See Also
6. Time Series Analysis
6.0. Introduction
6.1. Plotting Time Series Data
Problem
Solution
6.2. Adding Trendlines
Problem
Solution
6.3. Computing Moving Averages
Problem
Solution
Discussion
Moving Average trendline
Analysis ToolPak Moving Average
Spreadsheet formulas
See Also
6.4. Smoothing Data Using Weighted Averages
Problem
Solution
Discussion
Exponential smoothing
Kernel smoothing
See Also
6.5. Centering Data
Problem
Solution
Discussion
6.6. Detrending a Time Series
Problem
Solution
Discussion
See Also
6.7. Estimating Seasonal Indices
Problem
Solution
Discussion
See Also
6.8. Deseasonalization of a Time Series
Problem
Solution
Discussion
See Also
6.9. Forecasting
Problem
Solution
Discussion
6.10. Applying Discrete Fourier Transforms
Problem
Solution
Discussion
7. Mathematical Functions
7.0. Introduction
7.1. Using Summation Functions
Problem
Solution
Discussion
See Also
7.2. Delving into Division
Problem
Solution
See Also
7.3. Mastering Multiplication
Problem
Solution
Discussion
See Also
7.4. Exploring Exponential and Logarithmic Functions
Problem
Solution
Discussion
See Also
7.5. Using Trigonometry Functions
Problem
Solution
Discussion
7.6. Seeing Signs
Problem
Solution
Discussion
7.7. Getting to the Root of Things
Problem
Solution
Discussion
See Also
7.8. Rounding and Truncating Numbers
Problem
Solution
Discussion
7.9. Converting Between Number Systems
Problem
Solution
Discussion
See Also
7.10. Manipulating Matrices
Problem
Solution
Discussion
See Also
7.11. Building Support for Vectors
Problem
Solution
Discussion
7.12. Using Spreadsheet Functions in VBA Code
Problem
Solution
7.13. Dealing with Complex Numbers
Problem
Solution
Discussion
8. Curve Fitting and Regression
8.0. Introduction
8.1. Performing Linear Curve Fitting Using Excel Charts
Problem
Solution
Discussion
See Also
8.2. Constructing Your Own Linear Fit Using Spreadsheet Functions
Problem
Solution
Discussion
See Also
8.3. Using a Single Spreadsheet Function for Linear Curve Fitting
Problem
Solution
Discussion
See Also
8.4. Performing Multiple Linear Regression
Problem
Solution
Discussion
See Also
8.5. Generating Nonlinear Curve Fits Using Excel Charts
Problem
Solution
Discussion
See Also
8.6. Fitting Nonlinear Curves Using Solver
Problem
Solution
Discussion
8.7. Assessing Goodness of Fit
Problem
Solution
Discussion
See Also
8.8. Computing Confidence Intervals
Problem
Solution
Discussion
Confidence intervals for estimated values
Confidence intervals for curve parameters
See Also
9. Solving Equations
9.0. Introduction
Goal Seek
Solver
9.1. Finding Roots Graphically
Problem
Solution
Discussion
9.2. Solving Nonlinear Equations Iteratively
Problem
Solution
Discussion
Finding Cf with Goal Seek
Finding Cf with Solver
9.3. Automating Tedious Problems with VBA
Problem
Solution
Discussion
Automating Goal Seek
Automating Solver
See Also
9.4. Solving Linear Systems
Problem
Solution
Discussion
Matrix inversion
Using Solver with constraints
Using Solver to minimize residuals
9.5. Tackling Nonlinear Systems of Equations
Problem
Solution
Discussion
9.6. Using Classical Methods for Solving Equations
Problem
Solution
Discussion
Newton's method
Secant method
10. Numerical Integration and Differentiation
10.0. Introduction
10.1. Integrating a Definite Integral
Problem
Solution
Discussion
See Also
10.2. Implementing the Trapezoidal Rule in VBA
Problem
Solution
Discussion
See Also
10.3. Computing the Center of an Area Using Numerical Integration
Problem
Solution
Discussion
See Also
10.4. Calculating the Second Moment of an Area
Problem
Solution
Discussion
See also
10.5. Dealing with Double Integrals
Problem
Solution
Discussion
10.6. Numerical Differentiation
Problem
Solution
Discussion
See Also
11. Solving Ordinary Differential Equations
11.0. Introduction
11.1. Solving First-Order Initial Value Problems
Problem
Solution
Discussion
Using spreadsheet only
Using VBA
See Also
11.2. Applying the Runge-Kutta Method to Second-Order Initial Value Problems
Problem
Solution
Discussion
11.3. Tackling Coupled Equations
Problem
Solution
Discussion
Euler's method
Runge-Kutta method
11.4. Shooting Boundary Value Problems
Problem
Solution
Discussion
12. Solving Partial Differential Equations
12.0. Introduction
12.1. Leveraging Excel to Directly Solve Finite Difference Equations
Problem
Solution
Discussion
See Also
12.2. Recruiting Solver to Iteratively Solve Finite Difference Equations
Problem
Solution
Discussion
12.3. Solving Initial Value Problems
Problem
Solution
Discussion
12.4. Using Excel to Help Solve Problems Formulated Using the Finite Element Method
Problem
Solution
Discussion
See Also
13. Performing Optimization Analyses in Excel
13.0. Introduction
13.1. Using Excel for Traditional Linear Programming
Problem
Solution
Discussion
See Also
13.2. Exploring Resource Allocation Optimization Problems
Problem
Solution
Discussion
13.3. Getting More Realistic Results with Integer Constraints
Problem
Solution
Discussion
13.4. Tackling Troublesome Problems
Problem
Solution
Discussion
See Also
13.5. Optimizing Engineering Design Problems
Problem
Solution
Discussion
13.6. Understanding Solver Reports
Problem
Solution
Discussion
Answer report
Sensitivity report
Limits report
13.7. Programming a Genetic Algorithm for Optimization
Problem
Solution
Discussion
Genetic Algorithm Fundamentals
Chromosome class
Genetic optimization
Results
See Also
14. Introduction to Financial Calculations
14.0. Introduction
14.1. Computing Present Value
Problem
Solution
Discussion
See Also
14.2. Calculating Future Value
Problem
Solution
Discussion
See Also
14.3. Figuring Out Required Rate of Return
Problem
Solution
Discussion
See Also
14.4. Doubling Your Money
Problem
Solution
Discussion
14.5. Determining Monthly Payments
Problem
Solution
Discussion
See Also
14.6. Considering Cash Flow Alternatives
Problem
Solution
Discussion
See Also
14.7. Achieving a Certain Future Value
Problem
Solution
Discussion
See Also
14.8. Assessing Net Present Worth
Problem
Solution
Discussion
See Also
14.9. Estimating Rate of Return
Problem
Solution
Discussion
14.10. Solving Inverse Problems
Problem
Solution
Discussion
See Also
14.11. Figuring a Break-Even Point
Problem
Solution
Discussion
See Also
Index
About the Author
Colophon
SPECIAL OFFER: Upgrade this ebook with O'Reilly

Systemvoraussetzungen

Als PDF speichern Als Link merken