LEADER 04148nam 2200565 450 001 9910822513503321 005 20230803195633.0 010 $a1-61547-217-7 035 $a(CKB)2670000000547041 035 $a(EBL)1652816 035 $a(MiAaPQ)EBC1652816 035 $a(Au-PeEL)EBL1652816 035 $a(CaPaEBR)ebr10850209 035 $a(CaONFJC)MIL582361 035 $a(OCoLC)874322302 035 $a(EXLCZ)992670000000547041 100 $a20140404h20142014 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $2rdacontent 182 $2rdamedia 183 $2rdacarrier 200 10$aExcel 2013 for scientists /$fDr. Gerard M. Verschuuren ; Shannon Mattiza, cover design 205 $aRevised & expanded third edition. 210 1$aUniontown, Ohio :$cHoly Macro! Books,$d2014. 210 4$dİ2014 215 $a1 online resource (321 p.) 225 1 $aExcel for Professionals series 300 $aIncludes index. 311 $a1-61547-025-5 327 $aCover; Title page; Copyright page; Contents; About the Author; Introduction; Part 1: General Spreadsheet Techniques; Chapter 2: The Fill Handle; Chapter 3: Relative vs. Absolute Cell References; Chapter 4: Range Names; Chapter 5: Nested Functions; Part 1 Exercises; Part 2: Data Analysis; Chapter 7: Subtotals; Chapter 8: Summary Functions; Chapter 9: Unique Lists; Chapter 10: Data Validation; Chapter 11: Conditional Formatting; Chapter 12: Filtering Tools; Chapter 13: Lookups; Chapter 14: Working with Trends; Chapter 15: Fixing Numbers; Chapter 16: Copying Formulas 327 $aChapter 17: Multi-cell ArraysChapter 18: Single-cell Arrays; Chapter 19: Date Manipulation; Chapter 20: Time Manipulation; Part 2 Exercises; Part 3: Plotting Data; Chapter 22: A Chart's or Graph's Data Source; Chapter 23: Combining Chart Types; Chapter 24: Changing Graph Locations; Chapter 25: Templates and Defaults; Chapter 26: Axis Scales; Chapter 27: More Axes; Chapter 28: Error Bars; Chapter 29: More Bars; Chapter 30: Line Markers; Chapter 31: Interpolation; Chapter 32: Graph Formulas; Part 3 Exercises; Part 4: Regression and Curve Fitting; Chapter 34: Nonlinear Regression 327 $aChapter 35: Curve FittingChapter 36: Sigmoid Curves; Chapter 37: Predictability; Chapter 38: Correlation; Chapter 39: Multiple Regression: Linear Estimates; Chapter 40: Reiterations and Matrixes; Chapter 41: Solving Equations; Chapter 42: What-If Controls; Chapter 43: Syntax of Functions; Chapter 44: Worksheet Functions; Part 4 Exercises; Part 5: Statistical Analysis; Chapter 46: Types of Distributions; Chapter 47: Simulating Distributions; Chapter 48: Sampling Techniques; Chapter 49: Test Conditions and Outliers; Chapter 50: Estimating Means; Chapter 51: Estimating Proportions 327 $aChapter 52: Significant MeansChapter 53: Significant Proportions; Chapter 54: Significant Frequencies; Chapter 55: More on Chi-Squared Testing and Box-Cox Power; Chapter 56: Analysis of Variance; Part 5 Exercises; Index 330 $aWith examples from the world of science, this reference teaches scientists how to create graphs, analyze statistics and regressions, and plot and organize scientific data. Scientists can learn the tips and techniques of Excel-and tailor them specifically to their experiments, designs, and research. They will learn when to use NORMDIST vs NORMSDist and CONFIDENCE vs Z, how to keep data-validation lists on a hidden worksheet, use pivot tables to chart frequency distribution, generate random samples with various characteristics, and much more. Ideal for students and professionals alike, this hand 410 0$aExcel for Professionals series 606 $aComputer software$xDevelopment 606 $aElectronic spreadsheets 615 0$aComputer software$xDevelopment. 615 0$aElectronic spreadsheets. 676 $a005.1 700 $aVerschuuren$b G. M. N$g(Geert M. N.),$0863016 702 $aMattiza$b Shannon 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910822513503321 996 $aExcel 2013 for scientists$94086268 997 $aUNINA