Table of Contents

• 1. Introduction to Data in Healthcare
• 2. Working in Excel (R) and Importing Healthcare Data
• 3. Identifying, Categorizing, and Presenting Healthcare Data Using Excel (R)
• 4. Setting Bounds for Data and Hypothesis Testing Using Excel (R)
• 5. Testing the Mean Using Excel (R)
• 6. Checking Patterns in Data Using Excel (R)
• 7. Visualization and Spatial Analysis Using 3D Maps in Excel (R)
• 8. Analysis of Variance (ANOVA) in Excel (R)
• 9. Text Analysis of Healthcare Data using Meaning Cloud Add-in in Excel (R)
• 10. Sampling and Research Design Using Excel (R)
• 11. Answers and Video Tutorials to Practice Problems
• List of Select Sources of Healthcare Data
• Glossary

About the Author

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.