Excel for Scientists and Engineers
August 2005
Step by step instructions will have you up to speed in no time.
- 116 Pages
- Publisher: Holy Macro! Books
- ISBN: 1-932802-10-X
"Finally - Excel training written for scientists by a scientist!"
Are you tired of trying to learn Excel from an accountant? This book will cover the topics truly important to science and engineering professionals. Learn about sampling distributions and regressions and graphing.
Excel for scientists and engineers quickly guides the reader through topics such as sampling, estimating, distributions, testing, graphing, and data analysis. Being a scientist, Dr. Verschuuren hits upon the important topics that all accounting-centric books ignore.
"Covers the Basics and More In-Depth Tasks"
Learn the crucial Excel tricks to make your life will Excel more efficient, plus the book delves into statistical analysis, sampling distributions, transformations, estimating, trends, and more. Perform Multi-variate regression analysis with ease using this book.
"Why is it so impossibly hard to create a simple Histogram?"
Clearly, no one at Microsoft is a scientist. Why does it take a Ph.D. to put the columns together to make a histogram? Gerry Verschuuren has figured out the steps. Follow the charting chapter to create great-looking histograms and comparative histograms.
Add trendlines, error bars, normal distributions to your graphs
"I can estimate with confidence that you will enjoy this book!"
Learn how to estimate with confidence and more:
- Estimating with a T-Distribution
- Estimating with a Binomial Distribution
- Testing with Significance
- Testing with Normal and T-Distribution
- Testing with Chi-Square Distribution
- Testing with F-Distributions
I dare you to show the above list to any accountant and see if they have any clue what any of those topics mean. Don't try to learn Excel from an accountant.
-
General Techniques.
- Copies & Fills
- Relative vs. Absolute
- Telling Appearance from Reality
- Managing Dates
- Functions inside of Functions
-
Statistical Analysis.
- Sampling Distributions
- Estimating with confidence
- Testing with significance
-
Plotting Graphs.
- Types of charts
- Extra Axis
- Line vs XY Charts
- Error Bars
- Histrograms
- Special Effects & Dynamic Ranges
-
Regression Analysis
- Mon-factorial
- Curve fitting
- Multiple Regression
-
Complex Functions
- If, Index, VLOOKUP, Match
- Array Formulas
- Homemade Functions
- Functions inside Functions
-
Data Analysis.
- Validation
- Sorting Records
- Creating Subtotals
- Using data filters
- Database Functions
- Calculated Criteria
- Marked Records
-
Answers to Excercises.