Health Services Research and Analytics Using Excel - Paperback
Pay over time for orders over $35.00 with
Your all-in-one resource for quantitative, qualitative, and spatial analyses in Excel(R) using current real-world healthcare datasets.
Health Services Research and Analytics Using Excel(R) is a practical resource for graduate and advanced undergraduate students in programs studying healthcare administration, public health, and social work as well as public health workers and healthcare managers entering or working in the field. This book provides one integrated, application-oriented resource for 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 while cultivating analytical skills that are necessary in a data-driven healthcare world. Whereas Excel is typically considered limited to quantitative application, this book expands into other Excel applications based on spatial analysis and data 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 when navigating and analyzing data in the public domain or from internal data collection at their health services 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 for patterns; data visualization and spatial analysis; interpreting variance; text analysis; and much more. A concise overview of research design also provides helpful background on how to gather and measure useful data prior to analyzing in Excel. Because Excel is the most common data analysis software used in the workplace setting, all case examples, exercises, and tutorials are provided with the latest updates to the Excel software from Office365 ProPlus(R) and newer versions, including all important "Add-ins" such as 3D Maps, MeaningCloud, and Power Pivots, among others. With numerous practice problems and over 100 step-by-step videos, Health Services Research and Analytics Using Excel(R) 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:
- Provides a competency-based analytical approach to health services research using Excel
- Includes applications of spatial analysis and data visualization tools based on 3D Maps in Excel
- Lists select sources of useful national healthcare data with descriptions and website information
- Chapters contain case examples and practice problems unique to health services
- All figures and videos are applicable to Office365 ProPlus Excel and newer versions
- Contains over 100 step-by-step videos of Excel applications covered in the chapters and provides concise video tutorials demonstrating solutions to all end-of-chapter practice problems
- Robust Instructor ancillary package that includes Instructor's Manual, PowerPoints, and Test Bank
Nalin Johri, PhD, MPH, MA (Social Work) is an assistant professor and assessment coordinator in the Masters in Healthcare Administration (MHA) program/Department of Interprofessional Health Sciences and Healthcare Administration/School of Health and Medical Sciences at Seton Hall University and teaches several courses, including research methods, healthcare data analytics, healthcare economics, healthcare policy, and financial management. His areas of interest include program evaluation, competency-based assessment, and training. Dr. Johri is a frequent presenter on competency-based assessment at the Association of University Programs in Healthcare Administration (AUPHA) Annual Meetings and was invited by the Commission on Accreditation of Healthcare Management Education (CAHME) for a national webinar. Dr. Johri's work experience includes program development, monitoring, and evaluation experience on maternal and child health and nutrition and prevention of mother-to-child transmission of HIV. His experience spans over 10 years with nongovernmental organizations such as CARE and EngenderHealth, Francois-Xavier Bagnoud Center at the University of Medicine and Dentistry of New Jersey as well as consulting with UNICEF. Until April 2013 he was the Impact Evaluation Advisor for USAID's Palestinian Health Sector Reform Project. He holds a master's degree in social work from the Tata Institute of Social Sciences, Mumbai, India, a master's degree in public health (MPH) from Emory University, and a PhD in health policy and administration from the University of North Carolina at Chapel Hill.
Contributor(s)
Author
Free shipping on orders over $75. Standard shipping takes 3-7 business days. Returns accepted within 30 days of purchase.
Your all-in-one resource for quantitative, qualitative, and spatial analyses in Excel(R) using current real-world healthcare datasets.
Health Services Research and Analytics Using Excel(R) is a practical resource for graduate and advanced undergraduate students in programs studying healthcare administration, public health, and social work as well as public health workers and healthcare managers entering or working in the field. This book provides one integrated, application-oriented resource for 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 while cultivating analytical skills that are necessary in a data-driven healthcare world. Whereas Excel is typically considered limited to quantitative application, this book expands into other Excel applications based on spatial analysis and data 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 when navigating and analyzing data in the public domain or from internal data collection at their health services 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 for patterns; data visualization and spatial analysis; interpreting variance; text analysis; and much more. A concise overview of research design also provides helpful background on how to gather and measure useful data prior to analyzing in Excel. Because Excel is the most common data analysis software used in the workplace setting, all case examples, exercises, and tutorials are provided with the latest updates to the Excel software from Office365 ProPlus(R) and newer versions, including all important "Add-ins" such as 3D Maps, MeaningCloud, and Power Pivots, among others. With numerous practice problems and over 100 step-by-step videos, Health Services Research and Analytics Using Excel(R) 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:
- Provides a competency-based analytical approach to health services research using Excel
- Includes applications of spatial analysis and data visualization tools based on 3D Maps in Excel
- Lists select sources of useful national healthcare data with descriptions and website information
- Chapters contain case examples and practice problems unique to health services
- All figures and videos are applicable to Office365 ProPlus Excel and newer versions
- Contains over 100 step-by-step videos of Excel applications covered in the chapters and provides concise video tutorials demonstrating solutions to all end-of-chapter practice problems
- Robust Instructor ancillary package that includes Instructor's Manual, PowerPoints, and Test Bank
Nalin Johri, PhD, MPH, MA (Social Work) is an assistant professor and assessment coordinator in the Masters in Healthcare Administration (MHA) program/Department of Interprofessional Health Sciences and Healthcare Administration/School of Health and Medical Sciences at Seton Hall University and teaches several courses, including research methods, healthcare data analytics, healthcare economics, healthcare policy, and financial management. His areas of interest include program evaluation, competency-based assessment, and training. Dr. Johri is a frequent presenter on competency-based assessment at the Association of University Programs in Healthcare Administration (AUPHA) Annual Meetings and was invited by the Commission on Accreditation of Healthcare Management Education (CAHME) for a national webinar. Dr. Johri's work experience includes program development, monitoring, and evaluation experience on maternal and child health and nutrition and prevention of mother-to-child transmission of HIV. His experience spans over 10 years with nongovernmental organizations such as CARE and EngenderHealth, Francois-Xavier Bagnoud Center at the University of Medicine and Dentistry of New Jersey as well as consulting with UNICEF. Until April 2013 he was the Impact Evaluation Advisor for USAID's Palestinian Health Sector Reform Project. He holds a master's degree in social work from the Tata Institute of Social Sciences, Mumbai, India, a master's degree in public health (MPH) from Emory University, and a PhD in health policy and administration from the University of North Carolina at Chapel Hill.
Contributor(s)
Author