Project Report

INTRODUCTION

Patient no-shows permeate medical practices, across specialties, locations, and practice models. While no-shows consistently cause problems for practices, not all practices track their no-show rate or realize the impact that even a couple daily no-shows can have on both their processes and their revenue.

There are many reasons that patients fail to make their appointments and there are demographic similarities across patients who no-show more consistently than others. Practice managers work hard to reduce no-shows using a variety of strategies, but often those strategies involve manual processes or difficult-to-enforce policies, resulting in a low impact.

With the rise of EHR’s, Meaningful Use, and innovation in healthcare, the industry has developed some best practices to offer practice managers that eliminate manual work and have been shown to decrease no-show rates by over 50%.

This definitive guide explores the underlying causes of no-show behavior, outlines best practices, and shares how they work to reduce the manual workload of practice staff, serve patients better, and ultimately reduce patient no-shows.

Aims of the project

the aim of this project is to carry out an explanatory analysis of the no-show appointmentdata

Project Question

• Does the Time Interval Between Scheduled Day and Appointment Day Impact the No-Show Rate?
• Calculate the time interval in days
• Are there days when patients rarely visit the hospitals to meet up the appointment?
• To Extract specific day of the week from AppointmentDay
• Which Patients With Particular Diseases is likely to Come less for Appointment?
• Does the Age Group Have Impact on the No-Show Rate?
• Create age groups
• Does the Location Have Impact on the No-Show Rate?
• Calculate the no-show rate by neighbourhood
• Do patients with more than one disease increase no-show rate?
• Create a variable for the number of diseases
• Is the Follow-Up Scheme Used Appropriately?
• Calculate the no-show rate based on SMS received

R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

summary(cars)

##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.