Health Services Research and Analytics Using Excel® is a practical resource for graduate and advancedundergraduate students in programs studying healthcare administration, public health, and socialwork as well as public health workers and healthcare managers entering or working in the field. Thisbook provides one integrated, application-oriented resource for common quantitative, qualitative, andspatial analyses using only Excel. With an easy-to-follow presentation of qualitative and quantitativedata, students can foster a balanced decision-making approach to financial data, patient statistical dataand utilization information, population health data, and quality metrics while cultivating analytical skillsthat are necessary in a data-driven healthcare world. Whereas Excel is typically considered limited toquantitative application, this book expands into other Excel applications based on spatial analysis anddata visualization represented through 3D Maps as well as text analysis using the free add-in in Excel.Chapters cover the important methods and statistical analysis tools that a practitioner will face whennavigating and analyzing data in the public domain or from internal data collection at their healthservices organization. Topics covered include importing and working with data in Excel, identifying, categorizing, and presenting data, setting bounds and hypothesis testing, testing the mean, checking forpatterns, data visualization and spatial analysis, interpreting variance, text analysis, and much more. Aconcise overview of research design also provides helpful background on how to gather and measureuseful data prior to analyzing in Excel. Because Excel is the most common data analysis software usedin the workplace setting, all case examples, exercises, and tutorials are provided with the latest updatesto the Excel software from Office365 ProPlus® and newer versions, including all important "Add-ins"such as 3D Maps, MeaningCloud, and Power Pivots, among others. With numerous practice problemsand over 100 step-by-step videos, Health Services Research and Analytics Using Excel® is an extremelypractical tool for students and health service professionals who must know how to work with data, howto analyze it, and how to use it to improve outcomes unique to healthcare settings.