Just a short post about data and a common objection. At my current client, we have a lot of data about the customers (patients at a hospital) that we serve each day. We have measured the same way for about 4 months now so it’s pretty accurate.
Lately, I started to see a trend about how the patients are spread. Here’s a typical month. See how the Sundays are really bad (yeah, that’s the super low points). But there’s another trend here. The weeks keep falling - I thought at least. The Mondays are always best and the number of served patients gets lower and lower.
What can we learn from that?
Verification
First, I verified my hypothesis by proper analysis. I created an Excel formula that went through all our data and calculated the average per weekday.
There’s an Excel formula...