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…
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…
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…
Please see me my other Excel articles. Bar Chart: Comparing Distributions Vertically Sometimes when using a bar chart, you may find with too many categories, it is not feasible to display all the bars horizontally. In such cases, simply displaying bars vertically allows for many more categories to be compared within a chart. In this…
Please see me my other Excel articles. Stacked Column Chart: Comparing Distributions and Their Ranges Similar to the Bar Chart, chart allows you to compare categories, but also ranges of values within each category. In this example, I’ll begin with a data set consisting of adult-student grade averages listed by age group and US regions.…
Please see me my other Excel articles. Clustered Column Chart: Comparing Categories & Sub Categories Similar to bar chart previous described, this chart type provides an intuitive way to describe categories with the addition of sub categories as well. In this example, I will use this chart type to visually-describe a multiyear medical study of…
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…
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…
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…
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…
TechMbaBi 