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…

Excel: Chart – Bar

Please see me my other Excel articles. Use a Bar Chart to Communicate Important Trends In this article I will highlight important considerations when designing a bar chart to ensure its ability to intuitively illustrate patterns within data. First, I’ll begin with a simple data set of disease diagnoses for age groups beginning with new…

Excel: Chart – Area

Please see me my other Excel articles. Area Chart: Comparing Distribution Changes Between Data When comparing data distributions, there are times when it’s important to compare differences between categories at certain data points. In this example, I’ll begin with a data set comparing differences between school subject fees accumulated between two fiscal years. To create…

Central Tendency – Mode

Please see my other Statistics articles. Describing Central Tendency of Data Descriptive statistics is concerned with summarizing data using measurements. Here’s an example of descriptive statistics using the following data set: There are 20 statistics classes at a university for which all the ages of the students in one class have been collected – a…

Excel: Central Tendency – Median

Please see me my other Excel articles. Describing Central Tendency of Data Descriptive statistics is concerned with describing important aspects of set of measurements, organizing and summarizing data. Here’s an example of descriptive statistics using the following data set: There are 20 statistics classes at a university for which all the ages of the students…

Excel: Central Tendency – Mean

Please see me my other Excel articles. Describing Central Tendency of Data Descriptive statistics is concerned with summarizing data using measurements. Here’s an example of descriptive statistics using the following data set: There are 20 statistics classes at a university for which all the ages of the students in one class have been collected –…