Skip to Main Content
Data at Work: Best practices for creating effective charts and information graphics in Microsoft® Excel®
book

Data at Work: Best practices for creating effective charts and information graphics in Microsoft® Excel®

by Jorge Camões
April 2016
Beginner to intermediate content levelBeginner to intermediate
448 pages
10h 40m
English
New Riders
Content preview from Data at Work: Best practices for creating effective charts and information graphics in Microsoft® Excel®

10. Scattered Data

Henry Ford once remarked that “Half of my advertising budget is wasted, but I don’t know which half.” Similarly, we could say that half of our data are noise, but we don’t know which half. There is always signal (useful information) and noise (irrelevant variation) in a data set. Not only can we not always tell which is which, but signal and noise also change from task to task and from user to user.

In our pursuit of simplification and the good form, it would be ideal if we could reduce an entire data distribution to a single indicator like the mean, with an acceptable level of information loss. We can find such variables, but they’ll lack relevant variation and they’ll ultimately be useless.

However, we may be luckier than ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

The Big Picture: How to Use Data Visualization to Make Better Decisions—Faster

The Big Picture: How to Use Data Visualization to Make Better Decisions—Faster

Steve Wexler
Dashboards for Excel

Dashboards for Excel

Jordan Goldmeier, Purnachandra Duggirala

Publisher Resources

ISBN: 9780134268798Purchase book