Science 2013 for Scientists (book)

by Dr. Gerard M. Verschuuren


Published by Holy Macro Books! Uniontown, OH

Order from MrExcel here: www.MrExcel.com
Order the book from Amazon: www.Amazon.com
Order e-book version from Amazon: www.Amazon.com


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