You are previewing Statistics for Health Care Professionals: Working With Excel, 2nd Edition.
O'Reilly logo
Statistics for Health Care Professionals: Working With Excel, 2nd Edition

Book Description

Statistics for Health Care Professionals: Working with Excel (second edition) is written in a clear, easily followed style keyed to the powerful statistical tool, Microsoft Excel 2007. It introduces the use of statistics applicable to health administration, health policy, public health, health information management, and other professions, emphasizing the logic of probability and statistical analysis in all areas. Coverage includes data acquisition, data display, basics of probability, data distributions, confidence limits and hypothesis testing, statistical tests for categorical data, tests for related and unrelated data, analysis of variance, simple linear regression, multiple regression, and analysis with a dichotomous categorical dependent variable. A glossary and section-by-section review questions round out this uniquely comprehensive and accessible text.

Table of Contents

  1. Title Page
  2. Copyright Page
  3. PREFACE
    1. INTRODUCING EXCEL
    2. SO HOW DID WE GET TO HERE?
    3. INTENDED LEVEL OF THE TEXTBOOK
    4. TEXTBOOK ORGANIZATION
    5. LEADING BY EXAMPLE(S)
  4. Acknowledgments
  5. THE AUTHORS
  6. PART 1
    1. CHAPTER 1 - STATISTICS AND EXCEL
      1. 1.1 HOW THIS BOOK DIFFERS FROM OTHER STATISTICS TEXTS
      2. 1.2 STATISTICAL APPLICATIONS IN HEALTH POLICY AND HEALTH ADMINISTRATION
      3. 1.3 WHAT IS THE “BIG PICTURE”?
      4. 1.4 SOME INITIAL DEFINITIONS
      5. 1.5 FIVE STATISTICAL TESTS
    2. CHAPTER 2 - EXCEL AS A STATISTICAL TOOL
      1. 2.1 THE BASICS
      2. 2.2 WORKING AND MOVING AROUND IN A SPREADSHEET
      3. 2.3 EXCEL FUNCTIONS
      4. 2.4 THE =IF() FUNCTION
      5. 2.5 EXCEL GRAPHS
      6. 2.6 SORTING A STRING OF DATA
      7. 2.7 THE DATA ANALYSIS PACK
      8. 2.8 FUNCTIONS THAT GIVE RESULTS IN MORE THAN ONE CELL
      9. 2.9 THE DOLLAR SIGN ($) CONVENTION FOR CELL REFERENCES
    3. CHAPTER 3 - DATA ACQUISITION: SAMPLING AND DATA PREPARATION
      1. 3.1 THE NATURE OF DATA
      2. 3.2 SAMPLING
      3. 3.3 DATA ACCESS AND PREPARATION
      4. 3.4 MISSING DATA
    4. CHAPTER 4 - DATA DISPLAY: DESCRIPTIVE PRESENTATION, EXCEL GRAPHING CAPABILITY
      1. 4.1 THE =FREQUENCY() FUNCTION
      2. 4.2 USING THE PIVOT TABLE TO GENERATE FREQUENCIES OF CATEGORICAL VARIABLES
      3. 4.3 A LOGICAL EXTENSION OF THE PIVOT TABLE: TWO VARIABLES
      4. APPENDIX: USING EXCEL 2007 TO GENERATE PIVOT TABLES WITH ONE VARIABLE
    5. CHAPTER 5 - BASIC CONCEPTS OF PROBABILITY
      1. 5.1 SOME INITIAL CONCEPTS AND DEFINITIONS
      2. 5.2 MARGINAL PROBABILITIES, JOINT PROBABILITIES, AND CONDITIONAL PROBABILITIES
      3. 5.3 BINOMIAL PROBABILITY
      4. 5.4 THE POISSON DISTRIBUTION
      5. 5.5 THE NORMAL DISTRIBUTION
    6. CHAPTER 6 - MEASURES OF CENTRAL TENDENCY AND DISPERSION:DATA DISTRIBUTIONS
      1. 6.1 MEASURES OF CENTRAL TENDENCY AND DISPERSION
      2. 6.2 THE DISTRIBUTION OF FREQUENCIES
      3. 6.3 THE SAMPLING DISTRIBUTION OF THE MEAN
      4. 6.4 MEAN AND STANDARD DEVIATION OF A DISCRETE NUMERICAL VARIABLE
      5. 6.5 THE DISTRIBUTION OF A PROPORTION
      6. 6.6 THE T DISTRIBUTION
  7. PART 2
    1. CHAPTER 7 - CONFIDENCE LIMITS AND HYPOTHESIS TESTING
      1. 7.1 WHAT IS A CONFIDENCE INTERVAL?
      2. 7.2 CALCULATING CONFIDENCE LIMITS FOR MULTIPLE SAMPLES
      3. 7.3 WHAT IS HYPOTHESIS TESTING?
      4. 7.4 TYPE I AND TYPE II ERRORS
      5. 7.5 SELECTING SAMPLE SIZES
    2. CHAPTER 8 - STATISTICAL TESTS FOR CATEGORICAL DATA
      1. 8.1 INDEPENDENCE OF TWO VARIABLES
      2. 8.2 EXAMPLES OF CHI-SQUARE ANALYSES
      3. 8.3 SMALL EXPECTED VALUES IN CELLS
    3. CHAPTER 9 - t TESTS FOR RELATED AND UNRELATED DATA
      1. 9.1 WHAT IS A t TEST?
      2. 9.2 A t TEST FOR COMPARING TWO GROUPS
      3. 9.3 A t TEST FOR RELATED DATA
    4. CHAPTER 10 - ANALYSIS OF VARIANCE
      1. 10.1 ONE-WAY ANALYSIS OF VARIANCE
      2. 10.2 ANOVA FOR REPEATED MEASURES
      3. 10.3 FACTORIAL ANALYSIS OF VARIANCE
    5. CHAPTER 11 - SIMPLE LINEAR REGRESSION
      1. 11.1 MEANING AND CALCULATION OF LINEAR REGRESSION
      2. 11.2 TESTING THE HYPOTHESIS OF INDEPENDENCE
      3. 11.3 THE EXCEL REGRESSION ADD-IN
      4. 11.4 THE IMPORTANCE OF EXAMINING THE SCATTERPLOT
      5. 11.5 THE RELATIONSHIP BETWEEN REGRESSION AND THE t TEST
    6. CHAPTER 12 - MULTIPLE REGRESSION: CONCEPTS AND CALCULATION
      1. 12.1 INTRODUCTION
      2. 12.2 MULTIPLE REGRESSION AND MATRICES
    7. CHAPTER 13 - EXTENSIONS OF MULTIPLE REGRESSION
      1. 13.1 DUMMY VARIABLES IN MULTIPLE REGRESSION
      2. 13.2 THE BEST REGRESSION MODEL
      3. 13.3 CORRELATION AND MULTICOLINEARITY
      4. 13.4 NONLINEAR RELATIONSHIPS
    8. CHAPTER 14 - ANALYSIS WITH A ICHOTOMOUS CATEGORICAL DEPENDENT VARIABLE
      1. 14.1 INTRODUCTION TO THE DICHOTOMOUS DEPENDENT VARIABLE
      2. 14.2 AN EXAMPLE WITH A DICHOTOMOUS DEPENDENT VARIABLE: TRADITIONAL TREATMENTS
      3. 14.3 LOGIT FOR ESTIMATING DICHOTOMOUS DEPENDENT VARIABLES
      4. 14.4 A COMPARISON OF ORDINARY LEAST SQUARES, WEIGHTED LEAST SQUARES, AND LOGIT
  8. GLOSSARY
  9. REFERENCES
  10. INDEX