Cover image for Excel for Scientists and Engineers.
Excel for Scientists and Engineers.
Title:
Excel for Scientists and Engineers.
Author:
Verschuuren, Dr. Gerard.
ISBN:
9781615473137
Personal Author:
Physical Description:
1 online resource (180 pages)
Series:
Excel for Professionals series
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 Effects -- Working 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.
Abstract:
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.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: