Hi Reeza, Thanks for your reply! Yes it is operating at the daily level and is currently providing the accurate number of patients enrolled per day, except for days when no patients are enrolled. The values are not the same for each day. For example, 4/1/2018 4 patients were enrolled, 4/2/2018 1 patient was enrolled, 4/8/2018 no patients were enrolled but currently there exists no value for 4/8/2018 in the dataset for 4/82018 as it's only count days with patients enrolled. The goal is get a dataset with number of patients per day. Then assign the groups using enrollment date. Check normality of data, determine median or mean patients per day for each group. Use proper statistics to compare the mean or median patients per day in each group. Without the 0 values entered I won't have the true average number of patients per day, I will have the average number of patients enrolled per day for days which enrollment occured if that makes sense (which is not what I want). We are comparing admission of patients before and after COVID, assumption that COVID resulted in fewer admissions/ Thanks again for your help!!! Stephanie
... View more