We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Business People Are Dumb On Average(s)
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Data Management > Culture/Leadership > Business People Are Dumb On Average(s)
AnalyticsCulture/LeadershipData MiningData QualityDecision Management

Business People Are Dumb On Average(s)

Timo Elliott
Timo Elliott
7 Min Read
Business People Are Dumb On Average(s)
Photo by AS_Photography on Pixabay (https://pixabay.com/photos/digital-marketing-technology-1433427/)
SHARE

Here’s one real-life example of the limits in quantitative thinking observed in an average company, shared with me by Michael Thompson. He recently worked with Dan Rosenberg’s UX team on a SAP research project that isolated over 100 distinct, real-life uses of business analytics across dozens of roles and business functions.

A retail analyst was attempting to figure out the success of product promotions on the “sales” page of a web site. After gathering the data, he used Excel to create the table below. He compared the increase in each product sold with and without the promotions, and then tried to calculate the average percentage increase across the different products. The result was that “the promotions increased sales by 151% on average”.

This result was then used to create a rule-of-thumb of how much extra inventory the company should have on hand at the start of a promotion: “roughly double”. This lowball figure, it was felt, would generally provide enough stock for promotions, while reducing the chances that the company would be left with too much stock at the end of the promotion.

ProductAverage items sold prior 3 weeksItems sold during special promotion% increase
Kams Mint Toothpaste 8 oz7211256%
Peepers Size 5 Diapers 32 pack13417027%
Pata Negra Ham Sandwich354323%
Closers Breath Mints40112180%
Bboy Barbecue Charcoal 2lbs1798476%
Lindas Cookie Ice cream kids treats2665150%
Giant Corn Chowder Soup 12 oz can438495%
Silly String Cheese, Lunch pack1255358%
Green Label 6-pack beer120115-4%
Average of % increase in quantity  151%

 

More Read

Prediction, Influence and the Future of Power
Prediction, Influence and the Future of Power
Problems with the Language of Probability
Extreme Redundancy – Don’t Leave Home Without It!
Big Data Will Revolutionize Learning
Is Big Data Winning or Losing?

But there are a whole bunch of problems with this analysis. The most basic mathematical problem is that, while there are exceptions, calculating the average of percentages almost always gives an unwanted answer.

A better way to calculate the success of the promotions is to compare the average sales of all the products before and after a promotion (see table below). This shows that the promotions increased the average quantity of products sold by only 71% – considerably less than double.

ProductAverage items sold prior 3 weeksItems sold during special promotion% increase
Kams Mint Toothpaste 8 oz7211256%
Peepers Size 5 Diapers 32 pack13417027%
Pata Negra Ham Sandwich354323%
Closers Breath Mints40112180%
Bboy Barbecue Charcoal 2lbs1798476%
Lindas Cookie Ice cream kids treats2665150%
Giant Corn Chowder Soup 12 oz can438495%
Silly String Cheese, Lunch pack1255358%
Green Label 6-pack beer120115-4%
Average quantity55.494.8 
% Increase in average quantity*  71%

* note that it would be it would be easier to compare the % increase in totals items sold, which would come out to the same result, but I’ve used the averages to make the comparison between the two methods as obvious as possible.

So if the company did use the proposed rule of thumb they might have a nasty shock. Instead of an expected “lowball” inventory that would be used up by the promotions, they should instead expect to have an extra 29% of the original items left over at the end.

And beyond the numbers, there’s a lot of unanswered questions about the analysis that call into question its usefulness:

  • Is units sold the best measure? Wouldn’t it be better to work with revenue or profit?
  • There’s huge variability between the different categories of product. Is the notion of an average even meaningful? Maybe categories of products could be created for more meaningful analysis?
  • Do these percentages stay reliable over successive promotions, or are they also very variable?
  • Is it in fact better to have too little stock than too much? By how much?
  • Might external variables or seasonal variations have lead to the observed results, rather than the promotion? (e.g. maybe it was the 4th of July, and charcoal sales would have soared anyway)

In general, people are tempted to throw up their hands at this point and say “well, we have to make some sort of prediction for inventory levels – isn’t this better than nothing?” And the answer is yes (as long as you get the basic math right!), but somebody in the company should be aware of how limited the analysis currently is, and be constantly trying to improve it. Unfortunately, as in this case, real-world business people often rely on basic, faulty analysis, and lack the curiosity (or incentive?) to push it any further.

Given human nature, it’s probable that this example is not an isolated case. If you really want to improve your company’s return on investment in analytics, you may want to consider investing in more training rather than yet another technology solution.

Photo by Richard Riley/Flickr. Licensed under Creative Commons.

TAGGED:data analyticsmanagementstatistics
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection
Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
Big Data Business Intelligence Exclusive Web Analytics
Flat editorial illustration: A SaaS-editorial scene showing product usage, support patterns, and renewal feedback informing a fle
Using Product Usage Analytics and Support Data to Build a B2B Product Roadmap
Business Intelligence Infographic
From Hiring To Payroll: Managing HR Data Across Business Systems -- AI-generated illustration
From Hiring To Payroll: Managing HR Data Across Business Systems
Big Data Business Intelligence Infographic

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

The difference between Statistics and Machine Learning
Uncategorized

The difference between Statistics and Machine Learning

3 Min Read
unusual trading activity
AnalyticsExclusiveInfographic

Signal Or Noise? A Decision Tree For Evaluating Unusual Trading Activity

3 Min Read
ai data analytics
AnalyticsArtificial IntelligenceExclusive

How Internet Providers Are Using AI and Data Analytics To Help Customers

9 Min Read
Increased Data Analytics Capabilities Revolutionized The Tower Industry
Analytics

Increased Data Analytics Capabilities Revolutionized The Tower Industry

5 Min Read

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

Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?