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 […]
Category: STEM
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 […]
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 […]
Music Playback from a CSV (Python)
In my earlier blog post An Interactive Musical Keyboard Player (Python), I shared the full code on how to write an interactive musical keyboard that can also save what you play into memory and optionally to a file. In this post, I’ll share a related component as a separate code module that can read a […]
GDP Per Capita and PPP Adjusted GDP
We all know GDP (Gross Domestic Product), and GDP Per Capita is calculated by dividing the GDP of a nation by its population. Essentially, it represents how much economic production value can be attributed to each individual citizen. In this post, I present GDP=PPP and compare it to GDP Per Capita for selected countries to […]