Flylib.com
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors:
David M Bourg
BUY ON AMAZON
Using Excel
Introduction
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
Introduction
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 VBAs Built-in Functions
Exploring Excel Objects
Creating Your Own Objects in VBA
VBA Help
Collecting and Cleaning Up Data
Introduction
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
Introduction
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
Preparing Contour Plots
Annotating Charts
Saving Custom Chart Types
Copying Charts to Word
Recipe 4-14. Displaying Error Bars
Statistical Analysis
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Introduction
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
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
ISBN: 0596008791
EAN: 2147483647
Year: N/A
Pages: 206
Authors:
David M Bourg
BUY ON AMAZON
Qshell for iSeries
Running Qshell
The Integrated File System
Archives and Compression
Grep
Application Development Tools
Certified Ethical Hacker Exam Prep
Study Strategies
Key Terms
Study Strategies
Social Engineering
Title
The .NET Developers Guide to Directory Services Programming
Native Directory Services Programming Landscape
Understanding the ADSI Property Cache
Summary
Error 0x80072020: "An operations error occurred."
Error 0x8007202F: A constraint violation occurred.
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 2 Diagnosing and Troubleshooting
Domain 4 Motherboard/Processors/Memory
Domain 1 Operating System Fundamentals
Domain 3 Diagnosing and Troubleshooting
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Tools
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Credibility and the World Wide Web
GDI+ Programming with C#
Colors, Fonts, and Text
Clipping Regions Example
Coordinate Systems
Your First Printing Application
Reading and Writing Images to and from a Stream or Database
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies