Excel 2013 for scientists / by Gerard M. Verschuuren.

With 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....

Full description

Saved in:
Bibliographic Details
Main Author: Verschuuren, G. M. N. (Geert M. N.)
Format: eBook
Language:English
Published: Uniontown, Ohio : Holy Macro! Books, ©2014.
Edition:Revised & expanded 3rd edition.
Series:Excel for professionals series.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 a 4500
001 ocn874322302
003 OCoLC
005 20240809213013.0
006 m o d
007 cr cnu---unuuu
008 140322s2014 ohu o 001 0 eng d
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d TEFOD  |d E7B  |d DEBSZ  |d OCLCQ  |d OCLCO  |d OCLCF  |d N$T  |d OCLCQ  |d OCLCO  |d DOS  |d TEFOD  |d OCLCQ  |d YDXCP  |d OCLCQ  |d AGLDB  |d ZCU  |d MERUC  |d U3W  |d BUF  |d D6H  |d STF  |d VNS  |d OCLCQ  |d VTS  |d ICG  |d INT  |d VT2  |d OCLCQ  |d OCLCO  |d G3B  |d TKN  |d OCLCQ  |d OCLCO  |d DKC  |d AU@  |d OCLCQ  |d M8D  |d OCLCQ  |d OCLCO  |d AJS  |d OCLCO  |d OCLCQ  |d INARC  |d OCLCQ  |d OCLCO  |d OCLCL  |d SXB  |d OCLCQ  |d OCLCO 
019 |a 878142810 
020 |a 9781615472178  |q (electronic bk.) 
020 |a 1615472177  |q (electronic bk.) 
020 |a 9781615473380  |q (electronic bk.) 
020 |a 1615473386  |q (electronic bk.) 
020 |z 9781615470259 
035 |a (OCoLC)874322302  |z (OCoLC)878142810 
037 |a 244350F2-2808-46C9-A224-4478299AAE7F  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a QA76.76.D47  |b V477 2014eb 
050 4 |a HF5548.4.M523  |b V477 2014eb 
050 4 |a HF5548.4.M523 .V384 2014 
072 7 |a COM  |x 051390  |2 bisacsh 
072 7 |a COM  |x 051230  |2 bisacsh 
072 7 |a COM  |x 051440  |2 bisacsh 
049 |a HCDD 
100 1 |a Verschuuren, G. M. N.  |q (Geert M. N.)  |1 https://id.oclc.org/worldcat/entity/E39PBJpJbv8y66gtDBCpJpWbh3 
245 1 0 |a Excel 2013 for scientists /  |c by Gerard M. Verschuuren. 
250 |a Revised & expanded 3rd edition. 
260 |a Uniontown, Ohio :  |b Holy Macro! Books,  |c ©2014. 
300 |a 1 online resource (314 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Excel for Professionals series 
520 |a With 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 handbook will enable greater productivity and efficiency and it is updated to include all new functions in Excel 2010 and Excel 2013. 
500 |a Includes index. 
588 0 |a Print version record. 
505 0 |a Cover; 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. 
505 8 |a Chapter 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. 
505 8 |a Chapter 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. 
505 8 |a Chapter 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. 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Computer software  |x Development. 
650 0 |a Electronic spreadsheets. 
650 7 |a COMPUTERS  |x Programming  |x Open Source.  |2 bisacsh 
650 7 |a COMPUTERS  |x Software Development & Engineering  |x General.  |2 bisacsh 
650 7 |a COMPUTERS  |x Software Development & Engineering  |x Tools.  |2 bisacsh 
650 7 |a Computer software  |x Development  |2 fast 
650 7 |a Electronic spreadsheets  |2 fast 
758 |i has work:  |a Excel 2013 for scientists (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCFPKb99fxJDkb4jgdmCHfq  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Verschuuren, Gerard M.  |t Excel 2013 for scientists.  |b Revised & expanded third edition.  |d Uniontown, Ohio : Holy Macro! Books, ©2014  |h vi, 314 pages  |z 9781615470259 
830 0 |a Excel for professionals series. 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=1652816  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD