Statistics for Health Care Professionals: Working With Excel / Edition 2 available in Paperback
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.
|Series:||Public Health/Epidemiology and Biostatistics Series , #9|
|Edition description:||Older Edition|
|Product dimensions:||6.80(w) x 9.20(h) x 1.10(d)|
About the Author
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.
Table of Contents
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
What People are Saying About This
"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 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