Excel: Spread – Z-Scores

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…

Excel: Spread – Variance

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,…

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: 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…