Please see my other Statistics articles. Delivering Multidimensional Understanding In this article I will demonstrate how to use a data set to communicate joint (or two) distributions of data. First, I will convert the table into a relative cumulative table, beginning with the first age group (0-8). In this formula, I’m instructing Excel to divide…
Understanding Distribution Shapes and Central Tendency In many of my BI articles I discuss data and its measurements, one of the most commonly used being the mean (link) or average of all values within a data set. A data set contains many data points, their arrangement around the mean and their probably of occurrence is…
Please see me my other Excel articles. Histogram: Quickly Illustrate Relative Frequency In my Relative Frequency Histogram article I demonstrated how to transform a histogram to show each category’s value in comparison to the grand total of all diagnosis. In this article, I will show how to begin with a relative frequency histogram and replace…
Please see me my other Excel articles. Histogram: Comparing Distributions with Relative Frequency In my Histogram article I introduce a different version of the bar chart where instead of simply displaying ranges of values in each bar, you can display groups or categories of values (age groups and their diagnosis rates). In this article I…
Using Foreknowledge of Data Set Changes to Understand the Effects In most data studies, the original data set is modified to tease-out certain patterns. Knowing how certain changes affect metrics may prove a very useful tool when communicating results to clients. In this example, I will begin with a simple data set illustrating disease diagnoses…
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…
TechMbaBi 