LEADER 06871nam 22006975 450 001 9910437877503321 005 20200704163022.0 010 $a1-4614-5779-3 024 7 $a10.1007/978-1-4614-5779-4 035 $a(CKB)3400000000093761 035 $a(EBL)1082001 035 $a(OCoLC)823728986 035 $a(SSID)ssj0000851080 035 $a(PQKBManifestationID)11468268 035 $a(PQKBTitleCode)TC0000851080 035 $a(PQKBWorkID)10838326 035 $a(PQKB)11510409 035 $a(DE-He213)978-1-4614-5779-4 035 $a(MiAaPQ)EBC1082001 035 $a(MiAaPQ)EBC6314259 035 $a(PPN)168303884 035 $a(EXLCZ)993400000000093761 100 $a20121116d2013 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExcel 2010 for Biological and Life Sciences Statistics $eA Guide to Solving Practical Problems /$fby Thomas J Quirk, Meghan Quirk, Howard Horton 205 $a1st ed. 2013. 210 1$aNew York, NY :$cSpringer New York :$cImprint: Springer,$d2013. 215 $a1 online resource (247 p.) 300 $aDescription based upon print version of record. 311 $a1-4614-5778-5 320 $aIncludes bibliographical references and index. 327 $aExcel 2010 for Biological and Life Sciences Statistics; Preface; Acknowledgments; Contents; 1 Sample Size, MeanMean, Standard DeviationStandard deviation, and Standard Error of the MeanMean; 1.1...MeanMean; 1.2...Standard DeviationStandard deviation; 1.3...Standard Error of the MeanMean; 1.4...Sample SizeSample size, MeanMean, Standard DeviationStandard deviation, and Standard Error of the MeanMean; 1.4.1 Using the Fill/Series/Columns CommandsFill/Series/Columns commands; 1.4.2 Changing the Width of a Column; 1.4.3 Centering Information in a Range of Cells 327 $a1.4.4 Naming a Range of CellsNaming a range of cells1.4.5 Finding the Sample SizeSample size Using the =COUNT Function; 1.4.6 Finding the MeanMean Score Using the =AVERAGE Function; 1.4.7 Finding the Standard DeviationStandard deviation Using the =STDEV Function; 1.4.8 Finding the Standard Error of the MeanMean; 1.4.8.1 Formatting NumbersFormatting numbers in Number Format (2 Decimal Places); 1.5...Saving a SpreadsheetSaving a spreadsheet; 1.6...Printing a SpreadsheetPrinting a spreadsheet 327 $a1.7...Formatting NumbersFormatting numbers in Currency FormatFormatting numberscurrency format (2 Decimal Places)1.8...Formatting NumbersFormatting numbers in Number Format (3 Decimal Places); 1.9...End-of-Chapter Practice Problems; References; 2 Random Number Generator; 2.1...Creating Frame NumbersRandom number generatorframe numbers for Generating Random Numbers; 2.2...Creating Random Numbers in an Excel Worksheet; 2.3...Sorting Frame NumbersRandom number generatorframe numbers into a Random Sequence; 2.4...Printing an Excel File so that All of the Information Fits onto One Page 327 $a2.5...End-of-Chapter Practice Problems3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing; 3.1...Confidence Interval About the MeanConfidence interval about the mean; 3.1.1 How to Estimate the Population MeanMean; 3.1.2 Estimating the Lower LimitConfidence interval about the meanlower limit and the Upper LimitConfidence interval about the meanupper limit of the 95 Percent Confidence Interval About the MeanConfidence interval about the mean; 3.1.3 Estimating the Confidence Interval for the Chevy Impala in Miles Per Gallon 327 $a3.1.4 Where Did the Number ''1.96'' Come From?3.1.5 Finding the Value for t in the Confidence Interval Formula; 3.1.6 Using Excel's TINV Function to Find the Confidence Interval About the MeanConfidence interval about the mean; 3.1.7 Using Excel to find the 95 % Confidence Interval for a Car's mpg Claim; 3.2...Hypothesis TestingHypothesis testing; 3.2.1 Hypotheses Always Refer to the Population of People, Plants, or Animals that you are Studying; 3.2.2 The Null HypothesisHypothesis testingnull hypothesis and the Research (Alternative) Hypothesis 327 $a3.2.2.1 Determining the Null HypothesisHypothesis testingnull hypothesis and the Research HypothesisHypothesis testingresearch hypothesis When Rating Scales are Used 330 $aThis is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively.  It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems.  If understanding statistics isn?t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.  Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses.  Its powerful computational ability and graphical functions make learning statistics much easier than in years past.  However, Excel 2010 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems.  Practice problems are provided at the end of each chapter with their solutions in an appendix.  Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.  Includes 162 illustrations in color Suitable for undergraduates or graduate students. 606 $aStatistics 606 $aStatistics for Life Sciences, Medicine, Health Sciences$3https://scigraph.springernature.com/ontologies/product-market-codes/S17030 606 $aStatistics and Computing/Statistics Programs$3https://scigraph.springernature.com/ontologies/product-market-codes/S12008 606 $aStatistics, general$3https://scigraph.springernature.com/ontologies/product-market-codes/S0000X 615 0$aStatistics. 615 14$aStatistics for Life Sciences, Medicine, Health Sciences. 615 24$aStatistics and Computing/Statistics Programs. 615 24$aStatistics, general. 676 $a005.54 700 $aQuirk$b Thomas J$4aut$4http://id.loc.gov/vocabulary/relators/aut$0721655 702 $aQuirk$b Meghan$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aHorton$b Howard$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910437877503321 996 $aExcel 2010 for Biological and Life Sciences Statistics$92504205 997 $aUNINA