Verschuuren G. Excel 2007 for Scientists and Engineers

2nd edition. — Holy Macro! Books, 2008. — 275 p. — ISBN: 1932802355, 9781932802351.Designed by Scientists for Scientists.
With examples from the world of science and engineering, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Physicists and engineers can learn the tips and techniques of Excel and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this handbook will enable greater productivity and efficiency.
Dr. Gerard Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He has more than 20 years of experience teaching at colleges and corporations and is the author of many textbooks. He lives in Atkinson, New Hampshire.About the AuthorGeneral Techniques
Navigation in Excel 2007
The Fill Handle
Relative Vs. Absolute Cell References
Range Names
Nested Functions
Excercises
Data Analysis
Auto-numbering
Subtotals
Summary Functions
Unique Lists
Data Validation
Conditional Formatting
Filtering Tools
Lookups
Working with Trends
Fixing Numbers
Copying Formulas
Multi-cell Arrays
Single-cell Arrays
Date Manipulation
Time Manipulation
Excercises
Plotting Data
Types of Graphs
A Graph’s Data Source
Combining Graph Types
Changing Graph Locations
Templates and Defaults
Axis Scales
More Axes
Error Bars
More Bars
Line Markers
Interpolation
Graph Formulas
Excercises
Regression Analysis
Linear Regression
Nonlinear Regression
Curve Fitting
Sigmoid Curves
Predictability
Correlation
Multiple Regression: Linear Estimates
Reiterations and Matrixes
Solving Equations
What-If Controls
Syntax of Functions
Worksheet Functions
Excercises
Statistical Analysis
Why Statistics?
Types of Distributions
Simulating Distributions
Sampling Techniques
Each Test Has Its Own Conditions
Estimating Means
Estimating Proportions
Signifi cant Means
Signifi cant Proportions
Signifi cant Frequencies
More on the Chi-Squared Test
Analysis of Variance
Power Curves
Excercises