Visually Illustrating Relationships Venn Diagrams provide a very intuitive method for communicating relationships among categories in data. In this article I will demonstrate how to use a Venn diagram to illustrate an intersection of categories. I will begin with a simple data set consisting of simple survey results of respondents asked which luxury automobiles they…
Please see my other Statistics articles. Visually Illustrating Bounds, Median, Range Box and Whisker Plot provides a very efficient method for communicating several measurements. To illustrate how to create a box and whisker plot, I’ll use a free website and Excel. First, I’ll use the following link to access the free website. Now that my…
Ensuring Tables Intuitively Communicate Data During most data analysis, team members must review many small to large data sets. Often, these data sets resides within poorly designed tables, wasting much time when they should have first re-designed those tables to make the data more intuitive and easier to discern patterns. In this article, I will…
Please see my other Statistics articles. Choosing the Correct Method to Intuitively Communicate Data Patterns. Many options exist to intuitively communicate patterns in data for enable strategic decision-making. The following table recommends charts depending on your goals. Chart Purpose Example Bar, Pie Charts Simplest method for summarizing data. Note: Use a pie chart or horizontal…
Please see me my other Excel articles. Understanding Data Set Extremes Understanding the lower and upper limits of a data set may be the first and most necessary place to begin during any analysis. In this article, I will begin the same data set from my Chart – Bar article – disease diagnoses by age…
Please see me my other Excel articles. Understanding Inter-Medians As illustrated in my Median article (link) – understanding the median on a data set provides a helpful concept to know the value within the middle of all values of the data set. This article with illustrate median values within various divisions of the data set,…
Please see me my other Excel articles. XY Scatter Plot: Comparing Data Correlations Unlike other charts where data points form a contiguous shape whether in bars (bar chart) or slices (pie chart), scatter plot charts display distributions with individual data points, reflecting correlations between values. The name of this type of type begins with “XY”…
Please see me my other Excel articles. Quickly Communicating Data Points While many charts communicate data trends effectively, they do not do show them efficiently. In other words, if the user only requires a quick snap shot of the data, a verbose, heavy-graphic chart wastes valuable time on the part of the user when only…
Please see me my other Excel articles. Pie: Comparing Distributions of Data Pie charts provide a mechanism to compare distributions of data within a circle with the different categories touching each other. In this example, I’ll begin with a data set describing four medicines and their effectiveness. To create a bar chart, I’ll highlight the…
Please see me my other Excel articles. Using an Ogive to Communicate Accumulated Growth over Time In my line chart article I demonstrated how to create a line chart, or ogive, which is similar to a bar chart in that a trend over time is displayed, but an ogive only displays the greatest value for…
TechMbaBi 