Please see me my other Excel articles. Leveraging Z-Score to Understand Data Dispersion In my Standard Deviation article I demonstrated how to use the squared variance to show the average distance each data point resides from the mean. While variance and standard deviation illustrate data dispersion from the mean in terms of their precise location…

Please see me my other Excel articles. Using Variance to Determine Dispersion In my distributions articles (stats link) I illustrated distributions and how their shapes may be understood in terms of data points and their relation to the mean. Since the mean represents the average of all values, understanding the spread of all data points,…

# Excel: Spread – Standard Deviation

Please see me my other Excel articles. Leveraging Standard Deviation to Understand Data Dispersion In my Variance article I illustrated how to use variance to understand the average of all variances squared from the mean. In this article I will demonstrate how to determine standard deviation, which is simply the variance, squared. Excel provides the…

# Statistics: Distributions – Conditional

Isolating Patterns Based on Conditions In my Marginal Distributions article, I illustrated how to leverage a data set to isolate two marginal distributions in comparison with the grand total of all distributions, to arrive at specific distributions. This concept illustrates the concept of a conditional distribution in that a distribution is isolated based on a…

# Statistics: Distributions – Marginal

Isolating a Distribution’s Subset In my Joint Distributions article, I illustrated how to provide a data set using two (joint) distributions, with the Age Groups and Years distributions complementing each other. In this article I will demonstrate how to create a marginal distribution, which isolates one of the available distributions and measures it against the…

# Statistics: Distributions – Joint

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…

# Excel: Chart – Histogram (Frequency Polygon)

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…

# Excel: Chart – Histogram (Relative Frequency)

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…

# Statistics: Designing Data Tables

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…

# Statistics: Communication Options

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…