Minitab: Good for Statistics and for Shopping
I’m an avid shopper and coupon-clipper. I receive most of my coupons via e-mail and I often wonder what day of the week the best coupons will be e-mailed. In my attempt to live a Lean life, I think finding this out will save me time and prevent me from opening some of the hundreds of promotional e-mails I get each week.
Before performing any data analysis in Minitab, I decided to assign the e-mails in my inbox according to the following categories I think best rank each coupon’s worthiness:
Not worth your time
Offering average savings (A “noteworthy” deal)
So good you should skip work and go shopping
Based on my own personal preferences, I ranked coupons that included dollar savings (i.e., $10 off $25) higher than coupons that required the use of a store credit card to receive savings. I considered “not worth your time” e-mails to be those that were just promotional (i.e., "Check out our new summer styles") and didn’t include any coupons. I used four weeks of e-mail data (51 total messages) and I chose the following retailers to analyze: Kohl’s, Cabela’s, Express, and Victoria’s Secret.
Next, I ranked and tallied the coupons by color and recorded the numbers for each day.
Then I placed my data into Minitab (two-way table):
I used Minitab to create a clustered bar chart:
The majority of the coupons I received are what I consider “noteworthy” (28/51, or about 55%). The e-mails that contained coupons I considered “not worth your time,” were more frequent than I would have liked, making up about 35% of all the e-mails sent. The doorbuster savings were the least frequent e-mails, with only 16% falling under the “so good you should skip work and go shopping” category.
The majority of “noteworthy” or average savings were sent on Wednesdays and Fridays. “So good you should skip work” deals were most likely to be sent on Wednesdays, Thursdays, Fridays, and Sundays, but were never sent on Mondays, Tuesdays, or Saturdays.
Based on this Minitab output, I think Wednesdays, Thursdays, Fridays, and Sundays are the best days for me to open e-mails from the four retailers. The most “noteworthy” e-mails were sent during that time period, and the best chance for a “So good you should skip work” e-mail also occurs during this time. However, Wednesday-Saturday also had the best chance for receiving e-mails “not worth your time.”
If you'd like to analyze your own coupon data, my best advice is to focus on the e-mails from your favorite stores, and remember that there’s probably going to be a higher likelihood for better savings later in the week. Stay tuned for another shopping-related post.
Thanks to Kevin, Patrick, Cody, and Michelle for their help on this post!