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

Thomas Quirk ()
Additional contact information
Thomas Quirk: Webster University, School of Business and Technology

Chapter Chapter 3 in Excel 2010 for Educational and Psychological Statistics, 2012, pp 35-63 from Springer

Abstract: Abstract This chapter explains how to find the 95% confidence interval about the mean for a set of data and how to test hypothesis about your data using this confidence interval. You will learn how to estimate the population mean (average) for a group of people (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 and 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 for each chapter is presented in the Practice Test given in Appendix B along with answers in Appendix C of this book.

Keywords: Confidence Interval; Null Hypothesis; Research Hypothesis; Decimal Place; Excel Spreadsheet (search for similar items in EconPapers)
Date: 2012
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-1-4614-2071-2_3

Ordering information: This item can be ordered from
http://www.springer.com/9781461420712

DOI: 10.1007/978-1-4614-2071-2_3

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().