Skip to main content

Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing

  • Chapter
  • First Online:
Excel 2013 for Human Resource Management Statistics

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

  • 914 Accesses

Abstract

This chapter explains how to find the 95 % confidence interval about the mean for a set of data, and how to test hypotheses about your data using this confidence interval. You will learn how to estimate the population mean (average) for a group of events or objects at a 95 % confidence level so that you are 95 % confident that the population mean is between a lower limit of the data and an upper limit of the data. The formula for computing this confidence interval is presented, explained, and a sample problem is given using your calculator. You will then learn how to use Excel commands to determine the 95 % confidence interval about the mean using Excel’s TINV function. The second half of this chapter explains hypothesis testing and how you can test hypotheses about your data using Excel commands to find the 95 % confidence about the mean for your data. Seven steps are presented for this test, and you will be given specific explanations of how to write both the result and the conclusion of a hypothesis test. Alternative ways to summarize the result of a hypothesis test are also presented. 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
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  • Black K. Business statistics: for contemporary decision making. 6th ed. Hoboken: John Wiley& Sons, Inc.; 2010.

    Google Scholar 

  • Firz-enz J, Davison B. How to measure human resources management. 3rd ed. New York: McGraw-Hill; 2002.

    Google Scholar 

  • Keller G. Statistics for management and economics. 8th ed. Mason: South-Western Cengage Learning; 2009.

    Google Scholar 

  • McDaniel C, Gates R. Marketing research. 8th ed. Hoboken: John Wiley & Sons, Inc.; 2010.

    Google Scholar 

  • Salkind N. Statistics for people who (think they) hate statistics. 2nd Excel 2007 ed. Los Angeles: Sage Publications; 2010.

    Google Scholar 

  • Weiers R. Introduction to business statistics. 7th ed. Mason: South-Western Cengage Learning; 2011.

    Google Scholar 

  • Zikmund W, Babin B. Exploring marketing research. 10th ed. Mason: South-Western Cengage Learning; 2010.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Quirk, T.J., Palmer-Schuyler, J. (2016). Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing. In: Excel 2013 for Human Resource Management Statistics. Excel for Statistics. Springer, Cham. https://doi.org/10.1007/978-3-319-28982-3_3

Download citation

Publish with us

Policies and ethics