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

Excel: Merging Worksheet Data

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

Excel

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…

Excel: VLookUp

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…