The goal of this book is to develop competencies in the use of quantitative and qualitative analysis as well as 3D Maps—all within Excel! This book works through real-world examples based on healthcare datasets. Developed from the standpoint of active learning and engagement in the real world, this textbook includes supplementary health datasets such as, Hospital Compare Assessment of Healthcare Providers and Systems (HCAHPS), historical and current National Health Expenditure, and Community Health Rankings. In addition, the book also includes a select list of categorized sources of healthcare data. This categorized list was developed as part of a Digital Humanities Seed Grant Through the Center for Faculty Development at Seton Hall University. Since tests of hypotheses are based on sample data, a brief overview of sampling and research design is included. In a first of its kind, this book provides a hands-on approach to analyzing hypothetical qualitative hospital review comments through the MeaningCloud Add-in. This qualitative analysis includes text categorization, sentiment analysis, and topic extraction. The book uses a competency-based, application-oriented approach through a conversational style. Each chapter starts with a short vignette to motivate the content and uses screen captures together with step-by-step commentary to explain the procedures undertaken in Excel. There is minimal use of statistical formulae and jargon and no appendices in this book—since the focus is on application and interpretation. To make the most of this book, make sure to use the supplementary datasets to work along with the examples in the text and complete the practice problems found at the end of specific chapters.
