Master Excel for Healthcare Research and Analytics

By MPH Johri, Nalin, PhD, “Health Services Research and Analytics Using Excel” is a comprehensive resource for graduate and advanced undergraduate students, as well as public health workers and healthcare managers, seeking to develop their analytical skills in the field of healthcare.

A Practical Guide to Quantitative, Qualitative, and Spatial Analyses

This book provides an integrated, application-oriented approach to common quantitative, qualitative, and spatial analyses using only Excel. With an easy-to-follow presentation of qualitative and quantitative data, students can foster a balanced decision-making approach to financial data, patient statistical data and utilization information, population health data, and quality metrics.

Expand your Excel skills beyond quantitative applications and explore spatial analysis and data visualization using 3D Maps, as well as text analysis with the free add-in in Excel.

Covering Essential Methods and Statistical Analysis Tools

Chapters cover the important methods and statistical analysis tools that a practitioner will face when navigating and analyzing data in the public domain or from internal data collection at their health services organization. Topics include:

• Importing and working with data in Excel
• Identifying, categorizing, and presenting data
• Setting bounds and hypothesis testing
• Testing the mean
• Checking for patterns
• Data visualization and spatial analysis
• Interpreting variance
• Text analysis

A Comprehensive Resource for Healthcare Professionals

A concise overview of research design provides helpful background on how to gather and measure useful data prior to analyzing in Excel. With numerous practice problems and over 100 step-by-step videos, this book is an extremely practical tool for students and health service professionals who must know how to work with data, how to analyze it, and how to use it to improve outcomes unique to healthcare settings.

Key Features

This book provides:

• A competency-based analytical approach to health services research using Excel
• Applications of spatial analysis and data visualization tools based on 3D Maps in Excel
• Lists of select sources of useful national healthcare data with descriptions and website information
• Chapters containing case examples and practice problems unique to health services
• All figures and videos applicable to Office365 ProPlus Excel and newer versions
• Over 100 step-by-step videos of Excel applications covered in the chapters
• Concise video tutorials demonstrating solutions to all end-of-chapter practice problems
• A robust Instructor ancillary package that includes an Instructor’s Manual, PowerPoints, and Test Bank