Chapter 13. Booleans: TRUE and FALSE
There’s a deceptively simple data type available in Excel.
They’re called Boolean values, and they’re just plain ol’ TRUE and FALSE. You might think that they are too basic and elementary to be useful in serious data analysis, but nothing could be further from the truth. In this chapter, you’ll plug Boolean values into logical formulas to do a variety of tasks, from cleaning up data to making whole new data points.
Are fishermen behaving on Lake Dataville?
Lake Dataville has so many enthusiastic fishermen that the Dataville government has had to impose limits on fishermen to make sure they don’t take all the fish!
Most fishermen love the rules, because they guarantee the supply of fish. But there’s always a handful of bad apples, and the government needs your help sifting through the catch records to find them.
You have data on catch amounts for each boat
There’s a complex system for each boat ID. Each ID tells you whether the boat is small or large and what kind of fish it catches. That determines the catch regulations for each boat.
The problem in dealing with this data is that you don’t ...
Get Head First Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
