Excel 2013 for biological and life sciences statistics : a guide to solving practical problems /

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 isn?t y...

Full description

Bibliographic Details
Main Authors: Quirk, Thomas J. (Author), Horton, Howard F. (Author), Quirk, Meghan (Author)
Format: Book
Language:English
Published: [Cham] : Springer, 2015
Series:Excel for statistics
Subjects:
Table of Contents:
  • Introduction
  • Sample size, mean, standard deviation, 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
  • Appendix B
  • Appendix C
  • Appendix D
  • Appendix E
  • Index