Statistics for Health Care Professionals: Working With Excel, 2nd Edition
September 2009, ©2009, Jossey-Bass
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
John F. Kros is an associate professor of marketing and supply chain management at East Carolina University College of Business, Greenville, North Carolina.
David A. Rosenthal is an associate professor in the Department of Health Informatics and Information Management at the University of Tennessee's Health Science Center, Memphis.
— James V. Porto, Ph.D., MPA, Director, Executive Master's Programs, Health Policy and Administration School of Public Health, University of North Caroline-Chapel Hill
"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
"The text is very intuitive and pragmatic in using Excel to teach statistical analysis to health professionals. I plan on using it as a desk reference for many years in the future"
— Andrew Matthews, MD, FACEP, medical director, Emergency Care Center, and advisory board member, CMC-NorthEast