By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Business People Are Dumb On Average(s)
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
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
Last updated: 2011/09/12 at 1:34 PM
Timo Elliott
7 Min Read
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.

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”.

More Read

data analytics reveals the benefits of MBA

Data Analytics Technology Proves Benefits of an MBA

Advances in Data Analytics Key to Business Website Optimization
Top 5 Reasons You Should Become a Data Analyst
Email Marketers Use Data Analytics for Optimal Customer Segmentation
4 Data Analytics Tools for Property Market Valuations

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%

 

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 analytics, management, statistics
Timo Elliott September 12, 2011
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

data analytics reveals the benefits of MBA
Analytics

Data Analytics Technology Proves Benefits of an MBA

9 Min Read
data analytics is essential for website UX design
Analytics

Advances in Data Analytics Key to Business Website Optimization

7 Min Read
reasons to become a data analyst
Data Science

Top 5 Reasons You Should Become a Data Analyst

6 Min Read
data analytics for better email marketing
Analytics

Email Marketers Use Data Analytics for Optimal Customer Segmentation

12 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-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?