The familiar saying, “Comparing apples to oranges,” suggests that it’s illogical to compare two distinct items. However, in the realm of statistics, such comparisons are not only possible but sometimes necessary. By establishing a uniform standard or metric, we can evaluate items that, at first glance, appear incomparable. In this article, I present some straightforward […]
Tag: STEM
Conditional Coloring of Bar, Column Charts: 3 Examples
There are times when we want specific colors for bars or column in Excel charts to represent certain values or categories. Unfortunately, this isn’t a default feature, and it necessitates manually coloring each bar or series, which doesn’t automatically adjust when the data is altered. However, there are ways to achieve that with a little […]
Creating a dynamic weather report visual in Excel
In this blog post, I’ll share how I created a professional looking weather report tile using Excel without using any charting or pivot tables, but just just formulas and data inputs that is repeatable and scalable to daily reports without any change in the workbook. Just input the new data, and the new visual is […]
McKinsey-style bar chart in Excel
In this post, I’ll demonstrate how to create a McKinsey-style bar chart using just symbols and formulas, without using any Excel’s built-in chart components. BENEFITS OF THIS TYPE OF CHART:▪ It’s basically a bar chart with end points of our choice and much more vertically space-efficient and flexible.▪ It’s based on formulas, we can even […]
Waterfall charts: Explained
Waterfall charts, also known as bridge charts can provide a clear view of how an initial value is affected by a series of intermediate positive or negative values. In this post, I offer some tips on when to use them, how to shape the data, and how to fine-tune them for a final presentation. The […]
Debt-to-GDP ratios
Debt-to-GDP ratio, an economic metric comparing a country’s government debt to its GDP, is important for evaluating economic stability and repayment ability. If we know the Debt-to-GDP ratio and the GDP, we can calculate the debt. So, if a country’s Debt-to-GDP ratio is 264% and its GDP is 100 units, then its debt would be […]
Population Stats – USA and the World
BIRTH RATES, DEATH RATES, ANNUAL GROWTH RATES FOR THE USA AND THE WORLD. At present (2024), in the United States, there is approximately 1 birth every 8.08 seconds. In the world, there are 256 births per minute (including USA). There are 323 deaths per hour in the USA, compared to 106 in the world (including […]
Champions League: Probabilities, Odds, Payouts
The Champions League final is set, featuring Borussia Dortmund versus Real Madrid. This post will cover the betting odds, payouts, and probabilities of various outcomes, as well as how to interpret and calculate them on your own. Who will you root for? An article I read online recently stated that according to Bet365, the Borussia […]
The Power of VSTACK (Excel)
When you have multiple tables or datasets, often in different files or sheets, and you need bring them together to get insights or do some reporting, combining them can be a tedious, unrewarding, and even an error-prone task. That’s why I present to you the power of VSTACK function in Excel that can make this […]
Calculating Margin of Error
The margin of error (MOE) for a survey tells you how near you can expect the survey results to be to the correct population value. It assesses the precision of a survey’s estimates. This is immensely useful and necessary for quality assurance.A smaller margin of error suggests that the survey’s results will tend to be […]