Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    big data analytics in transporation
    Turning Data Into Decisions: How Analytics Improves Transportation Strategy
    3 Min Read
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Is the express line really faster?
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Uncategorized > Is the express line really faster?
Uncategorized

Is the express line really faster?

DavidMSmith
DavidMSmith
5 Min Read
SHARE

You’re at the supermarket. Which line should you choose for fastest service?

Shopping lines

(The numbers are the number of items in each cart.) Dan Meyer wondered about this, and rather than merely speculating or diving into queue theory, went out and collected data. (A very Mythbusters attitude, of which I approve.) He spent ninety minutes watching the checkout lines at his local supermarket, counting the number of items in each shopper’s cart and the amount of time it took them to be checked out (from loading up their first item to completing the financial transaction), and the method of payment.

More Read

Vivek Kundra: Still the Alpha CTO and now the First Fed CIO
Data Breach and Spear Phishing
Reading – Viral Data in SOA: An Enterprise Pandemic
Are CMO’s Tracking Social Media and WOM?
Are Media Companies Out-Innovating Their Advertisers?

The conclusion? In the example above, you’re likely better off in the shorter line with one loaded cart, rather than the “express” lane with several carts with a few items. The reason is that it takes about 3 seconds to scan each item, but on average about 35 seconds to process each shopper. In the example above we have 11 items and 4 shoppers in the express line for a wait time of 176 seconds, versus 1 shopper and 19 items for a wait time of 96 seconds. Here’s the calculation, as done in R:

> shopping <->read.csv(

+ “http://spreadsheets.google.com/pub? …



You’re at the supermarket. Which line should you choose for fastest service?

Shopping lines

(The numbers are the number of items in each cart.) Dan Meyer wondered about this, and rather than merely speculating or diving into queue theory, went out and collected data. (A very Mythbusters attitude, of which I approve.) He spent ninety minutes watching the checkout lines at his local supermarket, counting the number of items in each shopper’s cart and the amount of time it took them to be checked out (from loading up their first item to completing the financial transaction), and the method of payment.

The conclusion? In the example above, you’re likely better off in the shorter line with one loaded cart, rather than the “express” lane with several carts with a few items. The reason is that it takes about 3 seconds to scan each item, but on average about 35 seconds to process each shopper. In the example above we have 11 items and 4 shoppers in the express line for a wait time of 176 seconds, versus 1 shopper and 19 items for a wait time of 96 seconds. Here’s the calculation, as done in R:

> shopping <- read.csv(

+ “http://spreadsheets.google.com/pub?key=tE9pXlYLwTAeiDWxL8h_viA&single=true&gid=0&range=A1%3AE37&output=csv”,

+ as.is=TRUE)

> shopping$seconds <- as.numeric(as.difftime(shopping$Total.Time))

> p1 <- coef(lm(seconds ~ Number.of.Items, shopping,subset=-8))

> p1

    (Intercept) Number.of.Items 

      35.309942        3.191313 

> p1 %*% c(4,11) # express lane

         [,1]

[1,] 176.3442

> p1 %*% c(1,19) # short lane

        [,1]

[1,] 95.9449


Note that there’s one outlier (row 8) in the data file which I’ve deleted (and Dan apparently did so, too). The “Intercept” in our regression is the average processing time, and “Number.of.items” is the time to process each item. I used matrix math to calculate the wait times in our example, because I’m that awesome (or lazy, depending on your perspective).

The situation is complicated a bit by the method of payment: cash is by far the fastest (about 18 seconds) compared to credit card or check payments (41 and 54 seconds respectively). If you’re curious, here’s how I got those numbers in R:

> fit <- lm(seconds ~ Number.of.Items + Payment – 1, shopping,subset=-8)

> coef(summary(fit))

                   Estimate Std. Error  t value     Pr(>|t|)

Number.of.Items    2.955684  0.2997510 9.860464 6.340141e–11

Paymentcard       41.198885  6.7016800 6.147546 9.237407e–07

Paymentcard/cash 128.310215 22.1575721 5.790807 2.505366e–06

Paymentcash       17.974740  7.4723845 2.405489 2.252260e–02

Paymentcheck      53.997121 16.9930735 3.177596 3.430851e–03

Even if all the express lane patrons were paying with cash, the shorter line is still better even when the single patron pays with a credit card (104 seconds versus 97 seconds waiting).

dy/dan: What I Would Do With This: Groceries

Link to original post

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

big data analytics in transporation
Turning Data Into Decisions: How Analytics Improves Transportation Strategy
Analytics Big Data Exclusive
AI and fund manager software
AI And The Acceleration Of Information Flows From Fund Managers To Investors
Artificial Intelligence Exclusive
sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Delicate Art of Pushing Back

6 Min Read

How to Make Sure Your CRM Dashboards Are More Than Just Pretty Pictures [VIDEO]

3 Min Read

NSF Symposium on Semantic Knowledge Discovery, Organization and Use

1 Min Read

The General Theory of Data Quality

9 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?