How Many Water Bottles Could a Filling Station Save?

Filling a water bottle at a public fountain is a pain. It never fits, so you have to tilt your bottle sideways—which makes it even harder to get the water into the narrow mouth. But there are new fixtures that solve this problem; you might have seen them in office buildings or airports. Along with a normal spout for drinking, there’s a special outlet just for bottles.

Well, here’s the thing. At my university they recently upgraded our ancient hallway fountain to this new kind. Cool, right? This particular model has a digital counter at the top that says “Bottles saved.” What? You know what this means? It means I can track the counter value over some significant period of time and see what happens.

I’ll be honest. I really can’t help myself in cases like this; I just love to collect data. I don’t even know what I’m looking for. I’m just looking.

Fountain of Truth

OK, let’s start with the numbers. Over several months, I usually checked the counter reading at least a couple times a day. So here is a plot of the counter value as a function of time. The units for time are in days, but I have converted the approximate hour into a fraction of a day.

So, what do you see here? These are my initial observations:

It’s fairly linear. If it was completely linear, then humans would be walking by and drinking at regular intervals. Of course, humans are never that predictable.

Cleary I didn’t gather much data on the weekends, so there are some blank areas. There’s a longer gap around day 40—that was Thanksgiving break.

Still, it seems like there wasn’t much fountain use on weekends. Friday afternoon and Monday morning values are pretty similar.

After about 60 days, the line flattens out. This was after final exams.

So let’s get a rough estimate of the usage rate in “counts per day.” This would be the slope of the data above. If I just fit the data as is (including the low use on weekends but deleting the vacation data points), I get an average bottle count rate of 22.29 per day. If that’s really the number of disposable bottles saved each day, that’s pretty great.