Excel 2007 for Scientists (CDROM)

by Dr. Gerard M. Verschuuren


Published by Holy Macro Books! Uniontown, OH

Order the CDROM from MrExcel: www.MrExcel.com
Order the CDROM from Amazon: www.Amazon.com


Module 1: Data Analysis
Summaries
Lookups and Trends
Filtering Tools
Getting the Right Numbers
Complex Formulas
 
Module 2: Plotting Data
Chart Basics
Axis Issues
Bars and Error Bars
Interpolation
Graph Formulas
 
Module 3: Curve Fitting
Linear & Non-Linear
Sigmoid/Logistics Curves
The Best Fit Test
Correlations
Solving Equations
 
Module 4: Statistical Analysis
Types of Distributions
Sampling Techniques
Estimating Margins
Testing for Significance
ANOVA and Chi-Squared