Excel for scientists / by Gerard M. Verschuuren.

Format:

Book

Author/Creator:

Verschuuren, G. M. N. (Geert M. N.)

Series:

Excel for Professionals series

Language:

English

Subjects (All):

Electronic spreadsheets.

Engineering--Data processing.

Engineering.

Science--Data processing.

Science.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (180 p.)

Edition:

1st ed.

Other Title:

Excel for scientists & engineers

Excel for scientists and engineers

Place of Publication:

Uniontown, Ohio : Holy Macro Books, c2005.

Language Note:

English

Summary:

For scientists and engineers tired of trying to learn Excel with examples from accounting, this self-paced tutorial is loaded with informative samples from the world of science and engineering. Techniques covered include creating a multifactorial or polynomial trendline, generating random samples with various characteristics, and tips on when to use PEARSON instead of CORREL. Other science- and engineering-related Excel features such as making columns touch each other for a histogram, unlinking a chart from its data, and pivoting tables to create frequency distributions are also covered.<

Contents:

Title Page; Copyright Page; Table of Contents; About the Author; Prologue; Chapter I: General Techniques; Making Copies and Trends; Understanding Relative versus Absolute; Telling Appearance from Reality; Managing Dates; Putting Functions Inside Functions; Chapter II: Statistical Analysis; Understanding Sampling Distributions; Estimating with Confidence; Testing with Significance; Chapter III: Plotting Graphs; Types of Charts; Manipulating Graphs; Adding an extra axis; Line Charts versus XY Charts; Using Error Bars; Using Histograms; Configuring Default Graphs; Putting Inserts in Graphs

Adding Special EffectsWorking with Dynamic Ranges; Chapter IV: Regression Analysis; Mono-factorial and Linear; Curve Fitting; Multiple Regression; Chapter V: Complex Functions; Fancy Functions; Array Formulas; Homemade Functions; Solving Equations; Chapter VI: Data Analysis; Validation; Sorting Records; Creating Subtotals; Using Data Filters; Database Functions; Calculated Criteria; Marked Records; Appendix A: Answers to Exercises

Notes:

"Designed by scientists for scientists."

Includes index.

ISBN:

9781615473137

1615473130

9781932802627

1932802622

OCLC:

795119912