ANLY482 AY2016-17 T2 Group23 Silver Daisies Analysis and Findings
Contents
Univariate Analysis
Appointment Duration
We performed univariate analysis on appointment duration to find out the current distribution and summary statistics and obtained the following results:
- Mean duration: 1:22
- Median duration: 1:12
- Standard deviation: 0:47
- Non-parametric distribution
Bivariate Analysis
We performed bivariate analysis on each independent variable to find out their individual effect on appointment duration and obtained the following main findings:
Appointment Clinic
The median duration differs from clinic to clinic. The longer average appointment duration includes SNEC (Singapore National Eye Center), NUH (National University Hospital), and NCC (National Cancer Centre). The shorter durations mainly come from neighborhood polyclinics, such as Geylang polyclinic, BMP (Bukit Merah Polyclinic), and CWC (Community Wellness Centre).
Appointment Purpose
From the distribution analysis, we can see that Ophthalmologist takes the longest duration while Tests takes the shortest duration.
Escort
Analyzing the appointment durations when there is Next-of-kin accompaniment vs Family (more than 1 NOK) accompaniment vs Medical escort accompaniment, we see a difference in median appointment durations. We conducted a non-parametric paired significance test and conclude that with the accompaniment of a medical escort, the median appointment duration is lower than the accompaniment of NOK or family.
Multivariate Regression
Stepwise Regression
As we have many independent variables and sub-variables, we will perform a stepwise multiple linear regression to select the relevant variables. The results also reveal how the partition splits are done.
Based on Box-Cox Transformations, the y variable (appointment duration), is transformed based on the suggested lambda value of 0.263. After which it is transformed again by 0.986, before reaching a suggested lambda value of 1.0, which signifies that no transformation is needed. The Residual by Predicted Plot is now show as below.
Durbin-Watson Autocorrelation Test
Durbin- Watson Number of Observations AutoCorrelation Prob<DW 2.0283551 1682 -0.0170 0.6574
Based on Durbin-Watson Test, there is no significant evidence to conclude that the model is autocorrelated.
Model Fit
Summary of Fit RSquare 0.318637 RSquare Adjusted 0.310849 Root Mean Square Error 2084.254 Mean of Response 14506.98 Observation (or Sum Weights) 1682
The Summary of Fit shows a R-square of 0.318, meaning that 31.8% of the relationship can be explained with the given parameters. The adjusted R-square is 0.311, which is only a little lower than R-square, showing little evidence that the model is overfitted.
