LEADER 03415nam 2200625Ia 450 001 9910454417703321 005 20200520144314.0 010 $a1-61547-313-0 010 $a1-932802-62-2 035 $a(CKB)1000000000703932 035 $a(EBL)839307 035 $a(OCoLC)795119912 035 $a(SSID)ssj0000384414 035 $a(PQKBManifestationID)11292580 035 $a(PQKBTitleCode)TC0000384414 035 $a(PQKBWorkID)10339231 035 $a(PQKB)10255729 035 $a(MiAaPQ)EBC839307 035 $a(Au-PeEL)EBL839307 035 $a(CaPaEBR)ebr10237066 035 $a(EXLCZ)991000000000703932 100 $a20050623d2005 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel for scientists$b[electronic resource] /$fby Gerard M. Verschuuren 210 $aUniontown, Ohio $cHoly Macro Books$dc2005 215 $a1 online resource (180 p.) 225 1 $aExcel for Professionals series 300 $a"Designed by scientists for scientists." 300 $aIncludes index. 311 $a1-306-09684-7 311 $a1-932802-10-X 327 $aTitle 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 327 $aAdding 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 330 $aFor 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.< 410 0$aExcel for Professionals series 606 $aElectronic spreadsheets 606 $aEngineering$xData processing 606 $aScience$xData processing 608 $aElectronic books. 615 0$aElectronic spreadsheets. 615 0$aEngineering$xData processing. 615 0$aScience$xData processing. 676 $a005.36 700 $aVerschuuren$b G. M. N$g(Geert M. N.)$0863016 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910454417703321 996 $aExcel for scientists$92154229 997 $aUNINA