Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to Make Numbers Meaningful: You’ve Been Usi...

How to Make Numbers Meaningful: You’ve Been Using Them Wrong Your Whole Life

When faced with lots of facts and figures, many people recoil. Big numbers can be intimidating.

That’s both unfortunate and fixable. In fact, even if you’re terrible at math, I can help you make numbers meaningful.

In this workshop, you’ll learn not only how to analyze any kind of data, but also how to crank it down into familiar comparisons that even your innumerate uncle can understand. You’ll learn how to turn spreadsheets into stories.

We’ll conclude with a group exercise in which you’ll apply these lessons to humanize various statistics.

As a result, you’ll be able to comb through any chart, database, or spreadsheet, and emerge with an essential takeaway that everyone remembers. With unflagging consistency, you’ll be able to turn metrics into meaning.

Jonathan Rick

May 01, 2018
Tweet

More Decks by Jonathan Rick

Other Decks in Business

Transcript

  1. That’s how many feet under water from which we detected

    a signal from MH370’s black box. 15,000
  2. 2,600 feet The maximum known depth at which giant squids

    swim 2,717 feet The Burj Khalifa (inverted) 3,000 feet
  3. 9,816 feet The deepest that any mammal (in this case,

    the Cuvier’s beaked whale) has been recorded swimming
  4. Statistic The black box from MH370 is 15,000 feet under

    water. Story The black box from MH370 is farther under water than the Titanic, which took a lifetime to locate.
  5. Statistics Statistics engage the brain. Statistics inform. Statistics tell. Stories

    Stories capture the heart. Stories inspire. Stories sell.
  6. Emphasize Differences of Quality, Not Quantity 1 Q U A

    L I T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  7. Quantity Mike Trout’s WAR score is 72.5. Quality Mike Trout

    is already a better baseball player than Hall of Famer Derek Jeter.
  8. Focus on the Individual 2 Q U A L I

    T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  9. 8 Million People Since 2000, antiretroviral drugs have saved the

    lives of eight million AIDS patients. Eight countries in sub-Saharan Africa have seen their death rates plummet by 75%. Every day, 7,256 fewer children die. Michael & Benedicta This is Michael and this is Benedicta, and they’re alive today thanks in large part to antiretroviral drugs.
  10. 200,000 Dead During the past several years of warfare and

    flight, more than 200,000 Syrians have died. They’ve died in bomb- ings. They’ve died in chemical weapons attacks. They’ve died attempting to flee their country. Alan Kurdi In 2015, a dozen Syrian refugees drowned off the coast of Turkey fleeing to Greece. Among the dead was Alan Kurdi, a three year old whose tiny drowned body was found, face down, on a beach off the Mediterranean Sea.
  11. Give Your Readers Internal Context 3 Q U A L

    I T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  12. No Context Snapchat now has 190 million daily active users.

    Context That’s up from 180 million last quarter, and from 130 million a year ago.
  13. Period DAU (Millions) Growth Q4 2017 190 5% Q3 2017

    180 5% Q2 2017 170 6% Q1 2017 161 24% Q4 2016 130 N/A Pro Tip
  14. Pro Tip Snapchat’s Daily Active Users 0 Q1 2017 Q2

    2017 Q3 2017 Q4 2017 Q4 2016 150 200 175
  15. Context Snapchat now has 190 million daily active users. That’s

    up from 180 million last quarter, and from 130 million a year ago. Characterization While this growth constitutes a healthy jump over the last year (44%), it’s only a slight uptick since the last quarter (5%).
  16. Context Snapchat now has 190 million daily active users. That’s

    up from 180 million last quarter, and from 130 million a year ago. Characterization While this growth constitutes a healthy jump over the last year (44%), it’s only a slight uptick since the last quarter (5%).
  17. Break Numbers Down Into Digestible Bites 4 Q U A

    L I T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  18. That’s how many threats Symantec tools block every day. That’s

    how many businesses depend on Symantec tools. That’s how many cybersecurity researchers work at Symantec. 142M 300K 4K
  19. That’s all it took for the malware known as “NotPetya”

    to cripple thousands of companies in 2017. 7 Minutes
  20. Number The cybersecurity breach affected 981,000 Americans. Percentage Stories capture

    the heart. Stories inspire. Stories sell. Percentage The cybersecurity breach affected 30% of Americans. Fraction The cybersecurity breach affected about 1 in every 3 Americans.
  21. Month For only $30 a month, you can change a

    child’s life. Day For only a dollar a day, you can change a child’s life.
  22. Year Get immediate access for just $52 a year. Week

    Get immediate access for just $1 a week.
  23. Years For 5 years of service, Marissa Mayer was paid

    $239 million. Week For 5 years of service, Marissa Mayer was paid $131K a day.
  24. Give Your Readers External Context; Use Analogies 5 Q U

    A L I T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  25. Number The length of an N.B.A. basketball court is 94

    feet. Analogy That’s about the length of three school buses.
  26. Number A bomb-sniffing dog can detect a teaspoon of chemical

    in a million gallons of water. Analogy That’s nearly enough to fill two Olympic-size swimming pools.
  27. Number The iPhone generates $88.4 billion in annual revenue for

    Apple. Analogy If the iPhone were its own company, its revenue would be as big as that of McDonalds and Coca-Cola, combined.
  28. Number In the last quarter, the iPad raked in revenue

    of $6 billion. Analogy If the iPad were its own company, its revenue would be as big as that of Yahoo, Facebook, LinkedIn, Twitter, Groupon, and Tesla, combined.
  29. Grams of Fat The Maximum Daily Intake USDA Recommends A

    Medium-Size Bag of Movie- Theater Popcorn 10 20 30 40 0
  30. 1. Emphasize differences of _______, not quantity. 2. Focus on

    the __________. 3. Give your readers internal _______. 4. Break numbers down into __________ bites. 5. Give your readers ________ context; use _________. LET’S RECAP
  31. 7 Easy Ways to Turn Spread- sheets Into Stories 6

    Q U A L I T Y | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  32. Create an Analogy A N A L O G Y

    | T I M E | L I K E L I H O O D | P O P U L A T I O N | T I M E | M O N E Y | B E N E F I T S
  33. More people have a mobile phone than a toilet. Only

    4.5 billion people have access to a clean, working toilet. WATERAID UK SPR EA D SH EET
  34. STO RY More people have a mobile phone than a

    toilet. Only 4.5 billion people have access to a clean, working toilet. WATERAID UK SPR EA D SH EET
  35. More than 350,000 women die during pregnancy or child- birth

    every year. THE HUFFINGTON POST SPR EA D SH EET
  36. STO RY A woman dies of pregnancy-related causes every 90

    seconds. That’s 1,000 moms a day. More than 350,000 women die during pregnancy or child- birth every year. HUFFPOST SPR EA D SH EET
  37. STO RY If you’re a girl in certain countries, you’re

    more likely to forcibly be married than to freely attend prom. 64 million girls are forced into child marriage every year. CARE SPR EA D SH EET
  38. STO RY That’s more people than the populations of America,

    Canada, and the European Union, combined. One billion people around the world go hungry every day. GLOBAL CITIZEN SPR EA D SH EET
  39. It would cost $30 billion a year to end global

    hunger. CARE SPR EA D SH EET
  40. STO RY American consumers spend nearly half this amount on

    Super Bowl goodies alone. It would cost $30 billion a year to end global hunger. CARE SPR EA D SH EET
  41. In launching the Kindle, Jeff Bezos boasted that the e-reader’s

    library contained 90,000 books. SPR EA D SH EET
  42. STO RY To own a Kindle is to have a

    Barnes & Noble at your fingertips. In launching the Kindle, Jeff Bezos boasted that the e-reader’s library contained 90,000 books. SPR EA D SH EET
  43. Google We’re proud to report that Pixel earned a DxOMark

    rating of 89. Apple We’re proud to report that iPhone earned the highest rating ever from DxOMark, an independent group that rates camera quality.
  44. Player Price Songs Price/ Song CD $75 15 $5 Flash

    $150 15 $10 MP3 CD $150 150 $1 Hard Drive $300 1,000 $0.30
  45. “The biggest thing about iPod is that it holds 1,000

    songs. Now, this is a quantum leap, because for most people, it’s their entire music library.” — STEVE JOBS
  46. “I’m not interested in knowing which processor model is in

    a phone. I want to know if the phone is fast.” — DAVID POGUE
  47. 1. Create an _______. 2. Translate numbers into ____. 3.

    Use “____ or ____” likely logic. 4. Cite __________ data. FINAL RECAP
  48. 6. Assign a _______ value. 7. Emphasize ________, not features.

    8. Use _____________ pricing. FINAL RECAP
  49. Bonus Tips 7 Q U A L I T Y

    | T H E I N D I V I D U A L | I N T E R N A L C O N T E X T | D I G E S T I B L E B I T E S | E X T E R N A L C O N T E X T
  50. Random Our system contains the following data: 200 million diagnoses

    82 million people 1 billion lab results 500 million procedures Percentage Stories capture the heart. Stories inspire. Stories sell. Alpha Our system contains the following data: 200 million diagnoses 1 billion lab results 500 million procedures 82 million people Ascending Our system contains the following data: 82 million people 200 million diagnoses 500 million procedures 1 billion lab results