One-Group t-Test for the Mean

Part of the Excel for Statistics book series (EXCELSTAT)


This chapter explains how to use one of the most popular and most helpful statistical tests in environmental science research: the one-group t-test for the mean. This test compares the mean of your data set against the hypothesized population mean for your data to determine if the difference between these two values is “large enough” to be considered a “significant difference.” The formula is presented, explained, and a practical example is given using your calculator. Seven steps are outlined for using this formula to test specific hypotheses about your data. These steps build on the hypothesis-testing steps you learned in Chap. 3 of this book. You will also learn how to find the absolute value of a number, how to find the critical value of t in the table given in Appendix E of this book, and how to state both the result and conclusion of your statistical test. In addition, the difference between the 95 % confidence interval about the mean (Chap. 3) and the one-group t-test is explained. Three practice problems are given at the end of the chapter to test your Excel skills, and the answers to these problems appear in Appendix A of this book. An additional practice problem is presented in the Practice Test given in Appendix B along with its answer in Appendix C of this book.


Null Hypothesis Rainbow Trout Research Hypothesis Decimal Place Number Format 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. Burt J, Barber G, Rigby D. Elementary Statistics for Geographers. New York: The Guilford Press; 2009.Google Scholar
  2. Foster, D.P., Stine, R.A., Waterman, R.P. Basic Business Statistics: A Casebook. New York, NY: Springer-Verlag, 1998.Google Scholar
  3. Hoshmand A R. Statistical Methods for Environmental and Agricultural Sciences (2nd ed.). Boca Raton, FL: CRC Press, 1998.Google Scholar
  4. Townend J. Practical Statistics for Environmental and Biological Scientists. Hoboken: John Wiley & Sons, 2002.Google Scholar
  5. Zikmund, W.G. and Babin, B.J. Exploring Marketing Research (10th ed.) Mason, OH: South-Western Cengage Learning, 2010.Google Scholar

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  1. 1.Webster UniversitySt. LouisUSA
  2. 2.BaileyUSA
  3. 3.Colorado Parks and WildlifeDenverUSA

Personalised recommendations