One-Group t-Test for the Mean

  • Chapter
  • First Online:
Excel 2019 for Social Science Statistics

Part of the book series: Excel for Statistics ((EXCELSTAT))

  • 712 Accesses

Abstract

This chapter explains how to use one of the most popular and most helpful statistical tests in social 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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
EUR 29.95
Price includes VAT (Germany)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
EUR 64.19
Price includes VAT (Germany)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
EUR 80.24
Price includes VAT (Germany)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free ship** worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  • Fetterman, D.M. Ethnography: Step-by-Step (3rd ed.). Los Angeles, CA: Sage Publications, 2010.

    Google Scholar 

  • Foster, D.P., Stine, R.A., Waterman, R.P. Basic Business Statistics: A Casebook. New York, NY: Springer-Verlag, 1998.

    Google Scholar 

  • Johnson, J.B. and H.T. Reynolds. Political Science Research Methods (6th ed.). Washington, D.C.: CQ Press, 2008.

    Google Scholar 

  • Pollock, P.H. III. The Essentials of Political Analysis. (3rd ed.). Washington, D.C.: CQ Press, 2009.

    Google Scholar 

  • Zikmund, W.G. and Babin, B.J. Exploring Marketing Research (10th ed.) Mason, OH: South-Western Cengage Learning, 2010.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Quirk, T.J. (2021). One-Group t-Test for the Mean. In: Excel 2019 for Social Science Statistics. Excel for Statistics. Springer, Cham. https://doi.org/10.1007/978-3-030-64333-1_4

Download citation

Publish with us

Policies and ethics

Navigation