Main description:

Statistics for Health Care Professionals

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.

Praise for Statistics for Health Care Professionals

"By using Excel to explain how to conduct a statistical analysis, students will thoroughly grasp not only the mechanics of statistics but the underlying rationale for statistical reasoning."
James V. Porto, PhD, MPA, Director, Executive Master′s Programs, Health Policy and Administration School of Public Health, University of North Carolina, Chapel Hil

"Using Excel to teach statistics helped my understanding and makes ultimate sense when teaching statistics in the health care field."
Scott Bankard, MPT, supervisor of acute rehabilitation services, Pitt County Memorial Hospital

"Thanks to this text, my graduate students actually enjoy our health care statistics course. I am struck by how much the authors cover, how clearly they convey some normally difficult concepts, and how much they incorporate new features found in Excel 2007, all in an easily understood manner."
David C. Burchfield, PhD, FHFMA, Associate Professor, Master′s of Health Administration, The University of Memphis

James E. Veney is a professor emeritus of health policy and administration at the University of North Carolina at Chapel Hill. He taught courses in research methodology, evaluation methodology, statistics, and international health systems.

Back cover:

Statistics for Health Care Professionals

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.

Praise for Statistics for Health Care Professionals

"By using Excel to explain how to conduct a statistical analysis, students will thoroughly grasp not only the mechanics of statistics but the underlying rationale for statistical reasoning."
James V. Porto, PhD, MPA, Director, Executive Master′s Programs, Health Policy and Administration School of Public Health, University of North Carolina, Chapel Hil

"Using Excel to teach statistics helped my understanding and makes ultimate sense when teaching statistics in the health care field."
Scott Bankard, MPT, supervisor of acute rehabilitation services, Pitt County Memorial Hospital

"Thanks to this text, my graduate students actually enjoy our health care statistics course. I am struck by how much the authors cover, how clearly they convey some normally difficult concepts, and how much they incorporate new features found in Excel 2007, all in an easily understood manner."
David C. Burchfield, PhD, FHFMA, Associate Professor, Master′s of Health Administration, The University of Memphis

James E. Veney is a professor emeritus of health policy and administration at the University of North Carolina at Chapel Hill. He taught courses in research methodology, evaluation methodology, statistics, and international health systems.

Contents:

Preface xi

Acknowledgments xv

The Authors xvii

PART ONE 1

1 STATISTICS AND EXCEL 3

2 EXCEL AS A STATISTICAL TOOL 29

3 DATA ACQUISITION: SAMPLING AND DATA PREPARATION 65

4 DATA DISPLAY: DESCRIPTIVE PRESENTATION,

5 BASIC CONCEPTS OF PROBABILITY 145

6 MEASURES OF CENTRAL TENDENCY AND DISPERSION: DATA DISTRIBUTIONS 185

PART TWO 235

7 CONFIDENCE LIMITS AND HYPOTHESIS TESTING 237

8 STATISTICAL TESTS FOR CATEGORICAL DATA 269

9 t TESTS FOR RELATED AND UNRELATED DATA 291

10 ANALYSIS OF VARIANCE 317

11 SIMPLE LINEAR REGRESSION 359

12 MULTIPLE REGRESSION: CONCEPTS AND CALCULATION 387

13 EXTENSIONS OF MULTIPLE REGRESSION 415

14 ANALYSIS WITH A DICHOTOMOUS CATEGORICAL DEPENDENT VARIABLE 453

GLOSSARY 483

REFERENCES 493

INDEX 495