Excel Scientific and Engineering Cookbook - Helion

ebook

Autor: David M Bourg
ISBN: 978-05-965-5317-3
stron: 446, Format: ebook
Data wydania: 2006-01-17
Księgarnia: Helion

Cena książki: 152,15 zł (poprzednio: 176,92 zł)
Oszczędzasz: 14% (-24,77 zł)

Osoby, które kupiły tę książkę, wybierały także »

Tagi: Excel

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.

Osoby które kupowały "Excel Scientific and Engineering Cookbook", wybierały także:

Excel 2019 VBA. Kurs video. Opanuj zdarzenia oraz formularze i prze 179,00 zł, (53,70 zł -70%)
Excel 2019 VBA. Kurs video. Opanuj podstawy i przećwicz je na 50 praktycznych przykładach 199,00 zł, (59,70 zł -70%)
Przetwarzanie danych w Excelu. Kurs video. Laboratorium Power Query 129,00 zł, (38,70 zł -70%)
Excel VBA. Kurs video. Budowanie procesu automatycznego raportowania 179,00 zł, (53,70 zł -70%)
Excel - szybkie przetwarzanie danych. Sztuczki i gotowe rozwiązania. Kurs video 59,00 zł, (17,70 zł -70%)

Spis treści

Excel Scientific and Engineering Cookbook eBook -- spis treści

Excel Scientific and Engineering Cookbook
- SPECIAL OFFER: Upgrade this ebook with OReilly
- A Note Regarding Supplemental Files
- Preface
  - 1. Who Should Read This Book
  - 2. Whats 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 OReilly