My wife has seizures a few times a month and takes medication for the seizures once a month. So I have two sets of dates - the dates of the seizures and the dates she got her medication.
I'm trying to determine whether there is any sort of pattern in the timing of the seizures vs. the medication. I hope to get some clues as to whether the medication is helping, whether she needs it more often, etc.
I'd appreciate any suggestions as to how to analyze these two sets of dates for any pattern/relationship. I'm not a data scientist, but I'm pretty good with Excel, so I'm hoping for something I can model in Excel.