# Science 2013 for Scientists (book)

## by Dr. Gerard M. Verschuuren

Published by *Holy Macro Books!* Uniontown, OH

Part 1: General Spreadsheet Techniques
Chapter 2: The Fill Handle
Chapter 3: Relative vs. Absolute Cell References
Chapter 4: Range Names
Chapter 5: Nested Functions
Part 1 Exercises
Part 2: Data Analysis
Chapter 7: Subtotals
Chapter 8: Summary Functions
Chapter 9: Unique Lists
Chapter 10: Data Validation
Chapter 11: Conditional Formatting
Chapter 12: Filtering Tools
Chapter 13: Lookups
Chapter 14: Working with Trends
Chapter 15: Fixing Numbers
Chapter 16: Copying Formulas
Chapter 17: Multi-cell Arrays
Chapter 18: Single-cell Arrays
Chapter 19: Date Manipulation
Chapter 20: Time Manipulation
Part 2 Exercises
Part 3: Plotting Data
Chapter 22: A Chart’s or Graph’s Data Source
Chapter 23: Combining Chart Types
Chapter 24: Changing Graph Locations
Chapter 25: Templates and Defaults
Chapter 26: Axis Scales
Chapter 27: More Axes
Chapter 28: Error Bars
Chapter 29: More Bars
Chapter 30: Line Markers
Chapter 31: Interpolation
Chapter 32: Graph Formulas
Part 3 Exercises
Part 4: Regression and Curve Fitting
Chapter 34: Nonlinear Regression
Chapter 35: Curve Fitting
Chapter 36: Sigmoid Curves
Chapter 37: Predictability
Chapter 38: Correlation
Chapter 39: Multiple Regression: Linear Estimates
Chapter 40: Reiterations and Matrixes
Chapter 41: Solving Equations
Chapter 42: What-If Controls
Chapter 43: Syntax of Functions
Chapter 44: Worksheet Functions
Part 4 Exercises
Part 5: Statistical Analysis
Chapter 46: Types of Distributions
Chapter 47: Simulating Distributions
Chapter 48: Sampling Techniques
Chapter 49: Test Conditions and Outliers
Chapter 50: Estimating Means
Chapter 51: Estimating Proportions
Chapter 52: Significant Means
Chapter 53: Significant Proportions
Chapter 54: Significant Frequencies
Chapter 55: More on Chi-Squared Testing and Box-Cox Power
Chapter 56: Analysis of Variance
Part 5 Exercises