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

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…

Statistics: Designing Data Tables

Please see my other Statistics articles. Ensuring Tables Intuitively Communicate Data During most data analysis, team members must review many small to large data sets. Often, these data sets resides within poorly designed tables, wasting much time when they should have first re-designed those tables to make the data more intuitive and easier to discern…

Statistics: Charts

Please see my other Statistics articles. Choosing the Correct Method to Intuitively Communicate Data Patterns. Many options exist to intuitively communicate patterns in data for enable strategic decision-making. The following table recommends charts depending on your goals. Chart Purpose Example Bar Chart Simplest method for summarizing data, especially for a smaller number of categories and…

Statistics

Please see my other Business Intelligence articles. Leveraging descriptiven and inferential statistics to deliver a competitive, data-drive strategy. Leveraging Free Tools in Statistics I’ve found the following free tools to be very useful when analyzing data. Mockaroo: Easily create large test data sets. https://mockaroo.com/ Meta-Chart: Easily create diagrams and charts. https://www.meta-chart.com/ Descriptive Statistics Descriptive statistics…