Category Archives: visualization

Quality Management 4: Histogram (any version of Excel)

Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.

Quality Management: Histogram in Excel

Continue reading Quality Management 4: Histogram (any version of Excel)

In-depth: Excel Recommended Charts

Now that we know about Excel Recommended Charts, let us explore it in-depth. This is an implementation of artificial intelligence or machine learning at your fingertips. Don’t underestimate it… exploit it.

Excel recommended charts

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

Continue reading In-depth: Excel Recommended Charts

Caution: Visual Interpretation Error in Data Analytics

We have seen how to put data bars in Excel (Bar charts with a difference). These help us compare any value with any other value visually. This helps us understand patterns in the data.

example for Visual Interpretation Error

If not used properly, this great feature can lead to confusion and misinterpretation as well. Here are common scenarios and the solutions.

Continue reading Caution: Visual Interpretation Error in Data Analytics

Quick Analysis should NOT be done quickly!

Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real benefit – as usual – is elusive and difficult to grasp in this “instant” mode of living life.

Quick Analysis

Read on to find out what you are missing – even if you know how to use Quick Analysis!

Continue reading Quick Analysis should NOT be done quickly!