Statistics for Health Care Management and Administration Working with Excel

by Rosenthal, David A.; Kros, John F.

• ISBN13: 9781119901679
• ISBN10: 1119901677
• Edition: 4th
• Format: Paperback
• Copyright: 2023-08-22
• Publisher: Jossey-Bass

Summary

The must-have statistics guide for students of health services

Statistics for Health Care Management and Administration: Working with Excel introduces the uses of statistics in healthcare management and administration using the features and functions of Microsoft Excel. The book introduces students to statistics within the context of health care, focusing on the major data and analysis techniques used in the field. Step-by-step instructions in the latest version of Excel and numerous annotated screen shots make examples easy to follow and understand.

This updated fourth edition provides the same content and explanations that have made the previous editions so popular, offering revisions drawn directly from universities where the book has been used. All content has been brought current with the newest version of excel, and changes in the field of healthcare administration are covered as well. Statistics for Health Care Management and Administration gets students off to a great start by introducing statistics in the context of their chosen field.

• Learn the basics of statistics in the context of Excel
• Understand how to acquire data and display it for analysis
• Master important concepts and tests, including regression
• Turn test results into usable information with proper analysis

This book not only helps students develop the necessary data analysis skills, but also boosts familiarity with important software that employers will be looking for.

Author Biography

David A. Rosenthal is a Chief Information Officer at CampusWorks, Inc. He has over 20 years of health care industry experience in both academic and practitioner settings, having served in roles specific to hospital information technology leadership, multispecialty practice administration, and ambulatory services project management. Rosenthal earned a Master of Public Administration degree from Valdosta State University, and a PhD in Technology Management from Indiana State University. David is a proud veteran of the U.S. Air Force, and resides in Oakland, Tennessee with his wife Allyson.

John F. Kros is the Vincent K. McMahon Distinguished Professor in the Marketing and Supply Chain Management Department in the College of Business at East Carolina University, in Greenville, North Carolina. He teaches business decision modeling, statistics, operations and supply chain management, and purchasing and materials management courses. Kros was honored as the College of Business’s Scholar/Teacher for 2004???2005, again in 2009???2010, was awarded the College of Business Commerce Club’s highest honor, the Teaching Excellence Award, for 2006 and again in 2011, in 2013???2014 was awarded the East Carolina Alumni Association Outstanding Teaching Award, and in 2014???2015 was awarded the Board of Governors Distinguished Professor for Teaching Award. Kros earned his PhD in systems engineering from the University of Virginia, his MBA from Santa Clara University, and his BBA from the University of Texas at Austin. His research interests include health care operations, applied statistics, design of experiments, multi-objective decision making, Taguchi methods, and applied decision analysis. His textbook titled Spreadsheet Modeling for Business Decisions is in the fifth edition. He is also coauthor of Health Care Operations and Supply Chain Management.

Table of Contents

Preface
Acknowledgments 
The Authors 

Part One 
Chapter 1- Statistics and Excel 
Chapter 2- Excel as a Statistical Tool
Chapter 3- Data Acquisition: Sampling and Data Preparation
Chapter 4- Data Display: Descriptive, Presentation, Excel Graphing Capability 
Chapter 5- Basic Concepts of Probability 
Chapter 6- Measures of Central Tendency and Dispersion: Data Distributions 

Part Two
Chapter 7- Confidence Limits and Hypothesis Testing 
Chapter 8- Statistical Tests for Categorical Data
Chapter 9- t Tests for Related and Unrelated Data 
Chapter 10- Analysis of Variance 
Chapter 11- Simple Linear Regression 
Chapter 12- Multiple Regression: Concepts and Calculation 
Chapter 13- Extensions of Multiple Regression 
Chapter 14- Analysis with a Dichotomous Categorical Dependent Variable 

Appendix A Multiple Regression and Matrices 


References 
Glossary 
Index