Skip to main content

One-Way Analysis of Variance (ANOVA)

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

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

  • 933 Accesses


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 (Chap. 3 of this book) or the one-group t-test of the mean (Chap. 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 (Chap. 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 human resource management 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 human resource management 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.

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

USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
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


  • Aamodt M, Surrette M, and Cohen D. Understanding statistics: a guide for I/O psychologists and human resource professionals. Belmont: WADSWORTH CENGAGE Learning; 2007.

    Google Scholar 

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

    Google Scholar 

  • Polit D F. Statistics for data analysis for nursing research. 2nd ed. Upper Saddle River: Pearson Education Inc.; 2010.

    Google Scholar 

  • Scott I, Mazhindu D. Statistics for health care professionals: an introduction. Thousand Oaks: Sage; 2005.

    Google Scholar 

Download references

Author information

Authors and Affiliations


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). One-Way Analysis of Variance (ANOVA). In: Excel 2013 for Human Resource Management Statistics. Excel for Statistics. Springer, Cham.

Download citation

Publish with us

Policies and ethics