EconPapers    
Economics at your fingertips  
 

One-Way Analysis of Variance (ANOVA)

Thomas J. Quirk
Additional contact information
Thomas J. Quirk: Webster University

Chapter Chapter 8 in Excel 2010 for Engineering Statistics, 2014, pp 171-187 from Springer

Abstract: Abstract So far in this book, you have learned how to test for the difference within one group of data between the mean of the group and the hypothesized population mean for the data using either the 95% confidence interval about the mean (Chapter 3 of this book) or the one-group t-test of the mean (Chapter 4 of this book). You have also learned how to test for the difference between the means for two groups of to determine if this difference was a “significant” difference (Chapter 5 of this book). In this chapter, you will learn how to test for the difference between groups on a single variable when you have three or more groups of data. A practical engineering problem is presented that walks you through the Excel steps needed to generate the output for a one-way ANOVA test. You will learn how to interpret the Summary Output table correctly, and how to test the hypotheses comparing the population means of the three or more groups to see if they are “significantly different from each other.” If this overall ANOVA test is produces a significant result, you will learn how to test the hypotheses comparing any two groups using an ANOVA t-test formula. This formula is presented, explained, and a practical engineering example is used delineating the five steps needed to perform this test using a calculator. Then, the Excel steps for using this formula are presented and 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.

Keywords: Null Hypothesis; Decision Rule; Fuel Injector; Research Hypothesis; Decimal Place (search for similar items in EconPapers)
Date: 2014
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-3-319-02830-9_8

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

DOI: 10.1007/978-3-319-02830-9_8

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 ().

 
Page updated 2025-12-10
Handle: RePEc:spr:sprchp:978-3-319-02830-9_8