Excel 2007 for Biological and Life Sciences Statistics A Guide to Solving Practical Problems /

• Main Authors: Quirk, Thomas J. (Author), Quirk, Meghan. (Author), Horton, Howard. (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic
• Language: English
• Published: New York, NY : Springer New York : Imprint: Springer, 2013.
• Subjects: Statistics.; Mathematical statistics.; Statistics for Life Sciences, Medicine, Health Sciences.; Statistics and Computing/Statistics Programs.; Statistics, general.
• Online Access: https://ezaccess.library.uitm.edu.my/login?url=http://dx.doi.org/10.1007/978-1-4614-6003-9

This 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 isnt...

Table of Contents:

• Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
• Random Number Generator
• Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing
• One-Group t-Test for the Mean
• Two-Group t-Test of the Difference of the Means for Independent Groups
• Correlation and Simple Linear Regression
• Multiple Correlation and Multiple Regression
• One-Way Analysis of Variance (ANOVA)
• Appendix A:� Answers to End-of-Chapter Practice Problems
• Appendix B:� Practice Test
• Appendix C:� Answers to Practice Test
• Appendix D:� Statistical Formulas
• Appendix E:� t-table
• Index.