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
    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 and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 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

NRC Report: Data Mining won’t find the Terrorists
Best of 2008: Measurement
Wolfram Talks About Wolfram Alpha
ETL, Data Quality and MDM for Mid-sized Business
Hybrid Cloud: You Don’t Have to Go All In

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

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
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Image
Uncategorized

5 Reasons Why Excel Isn’t Enough for Financial Reporting

14 Min Read

Gamification Must Drive Software Ergonomics

6 Min Read

Why No Regulation of Offshoring: Untangling the Gap Between Rhetoric and Action

9 Min Read

Anxious About BYOD?

6 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 chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

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?