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. The specific Excel steps are presented to test the “friendliness” of the front desk clerk at a hotel using a 10-point rating scale. 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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Fetterman DM (2010) Ethnography: step-by-step, 3rd edn. Sage, Los Angeles
Foster DP, Stine RA, Waterman RP (1998) Basic business statistics: a casebook. Springer, New York
Johnson JB, Reynolds HT (2008) Political science research methods, 6th edn. CQ Press, Washington DC
Pollock PH III (2009) The essentials of political analysis, 3rd edn. CQ Press, Washington DC
Zikmund WG, Babin BJ (2010) Exploring marketing research, 10th edn. South-Western Cengage Learning, Mason
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer Science+Business Media New York
About this chapter
Cite this chapter
Quirk, T.J. (2012). One-Group t-Test for the Mean. In: Excel 2007 for Social Science Statistics. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-3622-5_4
Download citation
DOI: https://doi.org/10.1007/978-1-4614-3622-5_4
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-3621-8
Online ISBN: 978-1-4614-3622-5
eBook Packages: Mathematics and StatisticsMathematics and Statistics (R0)