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 […]
Tag: datascience
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 […]
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 […]
Crime rates comparison: US Cities
Recently, I came across two articles, one titled “15 Cheapest, Safest Places To Live in the US” and another titled “12 Cities With Really High Salaries and Really Low Costs of Living”. You can read more about their methodologies on their respective sites if you’re interested. However, these artciles prompted me to ask questions on […]
Percentile…what it means, and how to use it
In statistics, the term percentile is a measure used to understand the distribution of data in a dataset. It’s a concept that allows us to rank and compare values, providing a deeper understanding of where a particular data point stands in relation to the rest of the data. The percentile of a value is the […]