Weitere Kapitel dieses Buchs durch Wischen aufrufen
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, plants, or animals) 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.
Bitte loggen Sie sich ein, um Zugang zu diesem Inhalt zu erhalten
Sie möchten Zugang zu diesem Inhalt erhalten? Dann informieren Sie sich jetzt über unsere Produkte:
Black, K. Business Statistics: for Contemporary Decision Making (6 th ed.). Hoboken, NJ: John Wiley & Sons, Inc., 2010.
Bremer, M. and Doerge, R.W. Statistics at the Bench: A Step-by-Step Handbook for Biologists. Cold Spring Harbor, NY: Cold Spring Harbor Laboratory Press, 2010.
Keller, G. Statistics for Management and Economics (8th ed.). Mason, OH: South-Western Cengage learning, 2009.
Levine, D.M. Statistics for Managers using Microsoft Excel (6 th ed.). Boston, MA: Prentice Hall/Pearson, 2011.
McDaniel, C. and Gates, R. Marketing Research (8 th ed.). Hoboken, NJ: John Wiley & Sons, Inc., 2010.
Salkind, N.J. Statistics for People Who (think they) Hate Statistics (2 nd Excel 2007 ed.). Los Angeles, CA: Sage Publications, 2010.
Townend, J. Practical Statistics for Environmental and Biological Scientists. Hoboken, NJ: John Wiley & Sons, Inc., 2002.
van Emden, H.F. Statistics for Terrified Biologists. Malden, MA: Blackwell Publishing, 2008.
Weiers, R.M. Introduction to Business Statistics (7 th ed.). Mason, OH: South-Western Cengage Learning, 2011.
Zikmund, W.G. and Babin, B.J. Exploring Marketing Research (10 th ed.). Mason, OH: South-Western Cengage learning, 2010.
- Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing
Ph.D., M.B.A., M.A. Thomas J. Quirk
Ph.D., M.A., B.A. Meghan Quirk
M.S., B.S. Howard Horton
- Springer New York
- Chapter 3
Neuer Inhalt/© ITandMEDIA, Product Lifecycle Management/© Eisenhans | vege | Fotolia