03415nam 2200625Ia 450 991045441770332120200520144314.01-61547-313-01-932802-62-2(CKB)1000000000703932(EBL)839307(OCoLC)795119912(SSID)ssj0000384414(PQKBManifestationID)11292580(PQKBTitleCode)TC0000384414(PQKBWorkID)10339231(PQKB)10255729(MiAaPQ)EBC839307(Au-PeEL)EBL839307(CaPaEBR)ebr10237066(EXLCZ)99100000000070393220050623d2005 uy 0engur|n|---|||||txtccrExcel for scientists[electronic resource] /by Gerard M. VerschuurenUniontown, Ohio Holy Macro Booksc20051 online resource (180 p.)Excel for Professionals series"Designed by scientists for scientists."Includes index.1-306-09684-7 1-932802-10-X 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 GraphsAdding 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 ExercisesFor 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.<Excel for Professionals seriesElectronic spreadsheetsEngineeringData processingScienceData processingElectronic books.Electronic spreadsheets.EngineeringData processing.ScienceData processing.005.36Verschuuren G. M. N(Geert M. N.)863016MiAaPQMiAaPQMiAaPQBOOK9910454417703321Excel for scientists2154229UNINA