IDEAS home Printed from https://ideas.repec.org/h/spr/sprchp/978-3-319-05260-1_8.html
   My bibliography  Save this book chapter

One-Way Analysis of Variance (ANOVA)

In: Excel 2010 for Health Services Management Statistics

Author

Listed:
  • Thomas J. Quirk

    (Webster University)

  • Simone Cummings

    (Webster University)

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 health services 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 health services 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.

Suggested Citation

  • Thomas J. Quirk & Simone Cummings, 2014. "One-Way Analysis of Variance (ANOVA)," Springer Books, in: Excel 2010 for Health Services Management Statistics, edition 127, chapter 0, pages 173-189, Springer.
    • Handle: RePEc:spr:sprchp:978-3-319-05260-1_8
    DOI: 10.1007/978-3-319-05260-1_8
    as

    Download full text from publisher

    To our knowledge, this item is not available for download. To find whether it is available, there are three options:
    1. Check below whether another version of this item is available online.
    2. Check on the provider's web page whether it is in fact available.
    3. Perform a
    for a similarly titled item that would be available.

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:sprchp:978-3-319-05260-1_8. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.