Excel: Quartile

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

Excel: Chart – XY Scatter Plot

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

Excel: Chart – Pie

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…

Excel: Chart – Line Chart

Please see me my other Excel articles. Line Chart: Displaying Trends Over Time Often in statistical studies the organization requires the ability to discern patterns within trends which spans dates. The Line Chart represents one of the best methods to display trends of time. In this article I will demonstrate how to display the effect…

Excel: Chart – Histogram

Please see me my other Excel articles. Histogram: Comparing Distributions Comparing distributions against each other using a value list yields rich insight. In this article I will describe how to use a column chart to compare data from a cancer study. I’ll begin with a data set which describes age groups and frequency of cancer…

Excel: Chart – Bubble

Please see me my other Excel articles. Bubble: Comparing Data Correlations and Variances Similar to XY Scatter Plot charts (above) where you compare correlations between data, you may elect to use a bubble chart to additionally view data variances. Beginning with the same data set for XY Scatter Plot charts example, I added some data…