One simple way to proceed would be to do a binomial logistic regression to determine statistical significance and confidence intervals, and then convert the results from the log-odds scale of the logistic regression to probability scales if you wish to present results in terms of probability differences or risk ratios.
With the standard logit link function in binomial regression, you model the log-odds of the event (in your case, a long_waitDNA
) as a function of predictors. You main predictor is Seasonpart-of-week, in your example a 2-level categorical variable for which we can take "Summer""weekday" as the reference level. Then the intercept of the logistic regression is the log-odds of a long_waitDNA
in Summeron a weekday, and the regression coefficient for Seasonpart-of-week would be the difference in log-odds between Winterweekend and Summer;weekday; equivalently, this Seasonregression coefficient is the log of the odds ratio for a long_waitDNA
between Winterweekend and Summerweekday. If that regression coefficient is significantly different from 0 then the null hypothesis of no difference between Seasonsweekend and weekday is not supported.
You would take the individuals into account with a random effect in a mixed logistic regression model. If the values available for each patient are already aggregated among the 5 years of data collection then you would be limited to a random effect for the intercept of the logistic regression model, allowing individuals to differ in the log-odds of a long_waitDNA
in Summeron a weekday while modeling a single log-odds-ratio in the Seasonpart-of-week coefficient.
Many people (including me) have difficulty in thinking about odds and odds ratios, but those values are easily transformed into probability values, differences in probabilities, or risk ratios to make your presentation easier for your audience to understand.
If you use the R glmer()
function in the lme4
package for this analysis, you would re-organize your data into a long form, with one row representing data for a single individual and a single seasonpart-of-week, labeled by individual and seasonpart-of-week in columns. The corresponding visitappointment observations could be represented by two columns, one for the number of long_waitsDNA
s ("successes" if you model the probability of a long_waitDNA
) and one for the number of non-short_waitsDNA
;s; alternatively, you could provide the proportion of long_waitsDNA
s as the outcome and use the total number of visitsappointments as a weight.