In an earlier blog How Well Are Your Incentives Working? I shared methods on how to calculate the various chances of success based on some campaign data (e.g. new sign-ups for membership) from various trials using Binomial distribution. In this post, I show how to determine if events occurred due to random chance or affected […]
Category: Analytics
Waffle Charts (3 methods + bonus)
Certainly! Here’s a revised version of your paragraph: Waffle charts might be familiar to you. These charts are characterized by small squares within a grid, providing a straightforward representation of ratios. This concept is akin to that of pie charts, area charts, or treemaps—the choice ultimately hinges on the target audience and personal taste. Waffle […]
Counting words/elements correctly in Excel
In some of my previous posts, you’ve already seen my Python examples on how to count words accurately in a document or in blocks of text (search for: Wordcloud). It’s also possible to count the words in Excel, but we have some gotchas there to be aware of. In this blog, I demonstrate some of […]
Analyses of Critical Words & Speeches!
In one of my earlier blogs, I shared the techniques and code to create Word Cloud using Python and Excel together in this article: Word Cloud III – Python & Excel Together Today, building on that, I’ll analyze some of the most historic speeches and/or documents that every kid should read and even memorize part […]
Putting together our Presidents (Infographic in Excel)
In several of my earlier blogs, I demonstrated working with raw data from multiple sources to generate visual and statistical analysis. You can find them in the following posts: Let’s Play With All The Presidents (Excel)-Part1 Let’s Play With All The Presidents (Excel)-Part2 Getting To Know Our Presidents In this blog, I share the combined […]
Be the right kind of ‘Mean’
No, I’m not talking about stingy, spiteful kind…rather mathematical mean: arithmetic and statistical means to be exact. In fact, a handful of mean functions and applications. In most common situations, when we say ‘Mean’ even the statisticians mean the Average…or the arithmetic mean we all know since early childhood. We continue use it because while […]
Bars within bars: Creating an Effectual Custom Chart
In this post, I’ll share some tips on how to create a visually impactful bar chart, rather bars within a bar in Excel that does not come out of the box, that can convey much information in an uncluttered way. There are several steps we need to take in order to take Excel’s built-in charts […]
How to treat Excel like a database to do complex SQL-like queries
One of the most under-utilized, most powerful query features come from Excel’s database functions. While primary usage of Excel is more as a traditional spreadsheet, and it myriad of formulas (and VBA macros), the database functions allow us to treat it like a database and query from its dataset much like SQL statements would from […]
A Risk Assessment Map—my approach
I’ve seen many pretty risk assessment maps over time. The issue I see with most of them is that they’re more of an illustration than a method meaning, they’re customized visuals with manual graphics that don’t scale well for different projects. In the post, I’ll share my approach…it’s based on applying basic statistical concept, development […]
Measuring and visualizing performance from raw transactions
Scenario We have transactional data for 3 months. We want to compare any month’s sales performance with our goals by category of products sold. The following information is available in one dataset: OrderID, Product, qty, price, date of order as they occurred. As we see below, they’re not tallied or grouped or sorted in any […]