Excel 2016 for Environmental Sciences Statistics A Guide to Solving Practical Problems /

This book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical environmental 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...

Full description

Main Authors: Quirk, Thomas J. (Author, http://id.loc.gov/vocabulary/relators/aut), Quirk, Meghan H. (http://id.loc.gov/vocabulary/relators/aut), Horton, Howard F. (http://id.loc.gov/vocabulary/relators/aut)
Corporate Author: SpringerLink (Online service)
Language:English
Published: Cham : Springer International Publishing : Imprint: Springer, 2016.
Edition:1st ed. 2016.
Series:Excel for Statistics,
Subjects:
Online Access:https://doi.org/10.1007/978-3-319-40057-0
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.