IDEAS home Printed from https://ideas.repec.org/h/spr/sprchp/978-1-4614-3622-5_1.html
   My bibliography  Save this book chapter

Sample Size, Mean, Standard Deviation, and Standard Error of the Mean

In: Excel 2007 for Social Science Statistics

Author

Listed:
  • Thomas J. Quirk

    (Webster University)

Abstract

This chapter deals with how you can use Excel to find the average (i.e., “mean”) of a set of scores, the standard deviation of these scores (STDEV), and the standard error of the mean (s.e.) of these scores. All three of these statistics are basic to the study of statistics and are used frequently within many additional statistical tests. The formulas are presented, explained, and a practical example is given for each formula that shows how the formula can be applied using a calculator. Then, the steps needed to compute these formulas using Excel commands are explained so that you can practice using Excel to use these formulas correctly. You will also learn how to use Fill/Series commands, how to change the width of a column, how to center information in a group of cells, how to give a “name” to a group of cells, how to find the sample size for a data set, how to format numbers with a specific number of decimal places, how to save an Excel worksheet into your computer, and how to print out an Excel worksheet. 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, 2012. "Sample Size, Mean, Standard Deviation, and Standard Error of the Mean," Springer Books, in: Excel 2007 for Social Science Statistics, edition 127, chapter 0, pages 1-20, Springer.
    • Handle: RePEc:spr:sprchp:978-1-4614-3622-5_1
    DOI: 10.1007/978-1-4614-3622-5_1
    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-1-4614-3622-5_1. 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.