Statistics for Health Care Professionals: Workingwith Excel (second edition of Statistics in Health Administration and Health Policy)
Buy Rights Online Buy Rights

Rights Contact Login For More Details

  • Wiley

More About This Title Statistics for Health Care Professionals: Workingwith Excel (second edition of Statistics in Health Administration and Health Policy)

English

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.

English

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.

English

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

English

"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, 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 profes­sionals. 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

loading