When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.
Continue reading Quality Management 6: Scatter Chart
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
Continue reading Quality Management 5: Histogram and Pareto
Pareto chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.
Continue reading Quality Management 5: Pareto Chart
Capture important moments while conference videos, eLearning, etc. using a powerful OneNote shortcut. These could be specific slides / demos / whiteboard content. Find out how to do it.
Continue reading OneNote: Instant visual notes while watching Videos
This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.
Continue reading Quality Management 4: Histogram using Pivot Table
Run charts are simple line charts drawn against time. The idea is to visualize the pattern and trend of captured data. The data could be about defects, issues, observations or variability. Let us see how to manage this using Excel.
Continue reading Quality Management 3: Create Run Charts in Excel
Show an Iterative Process using SmartArt:
SmartArt does not always work as you want it to. Here is how you tweak it to get the desired effect. 5 min video.
Download the presentation from here.