Let’s Be Reasonable

ByChuck McDanal

Before you do anything with your data, whether it’s for your own work, or something your team will see, take a look at it first and ask yourself: “Is this reasonable?” Just scroll through your spreadsheet — summarize or use pivot tables if you have a lot of data — and this can alert you to outliers, bad numbers, typos and other things that can ruin your day. A friend once did some great work where age was an important variable, but whenever the people entering the data couldn’t find it, they put in “999” to denote that it was missing. Using age without excluding those records made all the charts and tables and reports wrong because Excel happily factored in people who were 999 years old. A quick scan through the data would have caught this because someone who is 999 is not reasonable. #makeyourdataworkforyou

Chuck McDanal is the owner of StudioC and has more than 25 years of experience in a range of roles, from managing an IT department to working as an editor; from directing a large operation to leading an internet startup and creating a 501(c)(3) nonprofit from the ground up. He has extensive experience in process improvement, data analytics, coaching, mentoring, facilitation, strategic planning, managing and leading. Chuck also is a Certified Analytics Professional, an RRCA-certified running coach, has a certificate from the Wharton School in Business Analytics, is a Six Sigma Black Belt, and is a professional coffee roaster. He has served on multiple community boards and organizations, which currently includes the Lakeland Symphony Orchestra and Lakeland Vision. He is a graduate of Leadership Lakeland and Leadership Polk, and was Chair-elect of Leadership Lakeland Class 36 and Chair of Class 37. Chuck was named 2020 Businessman of the Year by the Lakeland Chamber of Commerce. He recently published a book called “Human Training,” which is available on Amazon and through other resellers.

Similar Posts

‘Tis the Season

Many of you deal with seasonality in your data. Maybe it’s busier in the months when snowbirds are here or slower when everyone is vacationing in the summer. If you’re like many others, you are smart enough to avoid comparing consecutive months because of this variation, and often all you can do is look at…

Don’t Ask

So many times we go to do something online and we are asked for all sorts of information. Let’s think about this in two buckets: What does the company or organization actually NEED from you to conduct whatever business you are doing? And what else are they asking for? For most things, when you get…

Visualizing Data

There are so many beautiful ways to look at data, and the best of them paint a picture the numbers alone might not show so readily. From classics such as Snow’s cholera map or Minard’s Napoleon map, to your basic spreadsheet charts, entire specialties are devoted to depicting information in a useful way. So what…

Part I: Out Front

We see companies and organizations writing heartfelt posts and emails, first during the pandemic, and now because of the racial wounds hurting the nation. Initially, I kept my own feelings confined to a circle of family and friends. As important as these issues are, they didn’t seem relevant to my data and coaching work. But…

Why Train?

Seems like an unnecessary question. But most of us know it’s not. When we have good people in our organizations, we love to see them do well and grow. So let’s take a minute to think about what WE are doing to foster that. Did you promote a shiny employee to a managerial role? How…