SSSVEDA DAY 1 – Beware of Ghost Peppers & Suspect Excel Charting

What to do when you are offered ghost peppers or Trinidad scorpion peppers? Which one would you choose? Oz is here to help us out.

Let’s get started!

1 – The Evidence

The chart on the right displays the Scoville Heat Units (SHU) of different peppers. Poblano isn’t even that hot. And Trinidad scorpion peppers doesn’t even score twice as hot. I guess, we can handle it after all.1 25
1 25

But, wait a minute! Is there some trickery at work here?

2 – The Deception

When we add vertical axis to our chart, the entire result changes. Turns out that the creator of this chart had enabled logarithmic scale using Axis Options. Of course, he then deleted the scale to hide any trace of the change!2 192 192 19

You can also see here the data that was used to create this chart. It is pretty apparent ghost peppers and Trinidad scorpion peppers are something we all should generally stay away from.

3 – To Remember

Always remember to take a look at the data! There are no two ways about it. Getting yourself in the habit of observing the data before believing any charts or analytics will prove to be immensely valuable to any aspiring data analyst. It has certainly helped me!

What’s next?

A big part of our jobs is to be aware of possible pitfalls in data analysis. So do not forget to share this video as widely as you can. And write your thoughts to us in the comments section below.

Youtube

And while you are at it… Check out all the great Excel videos on Oz’s Youtube channel.  He’s on Fire.


Tags


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
    • SSSVEDA is 2 things:
      VEDA is a general movement called Vlog EveryDay in April
      I took on the challenge and successfully uploaded a video on about 24 of the 30 days in April

      The SSS part refers to the person who led a bunch of us through the VEDA challenge. Her YouTube channel is SavvySexySocial.

      Thanks for the question, Carlito!

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.

    >