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…
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 –…
Consolidating data into one Excel worksheet. This post describes how to merge data in an Excel workbook containing worksheets with data where each worksheet has differing number of columns and rows. I will use a spreadsheet which contains three tabs/worksheets with the following columns. Sheet1 will be the first source worksheet used to import data.…
Please see my other Business Intelligence articles. Leveraging Excel to deliver analytics. CHARTS Chart: Area Chart: Bar Chart: Bar – Clustered Chart: Bar – Stacked Chart: Bar – Vertical Chart: Bubble Chart: Histogram Chart: Histogram – Frequency Polygon Chart: Histogram – Relative Frequency Chart: Line Chart: Ogive Chart: Pie Chart: Stem & Leaf Plots…
Creating a list lookup. Many Excel spreadsheets contain data spread across many different worksheets and in collaboratively work environments, worksheets are shared among coworkers. The result of this data separation is that sometimes a scenarios arises when critical data is needed but unavailable by the current spreadsheet. To overcome this limitation, I will use the…
TechMbaBi 