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 […]
Tag: Excel
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 […]
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 […]
Home Prices across USA and other metrics
In this blog post, I delve into an extensive collection of data and computations related to home prices across the United States. I examine the affordability of homes in each state, including Washington D.C., by taking into account regional income, down payment, loan costs, and mortgage payments. I also consider the minimum salary requirements needed […]
Gini Coefficient and how to calculate it
The Gini Coefficient is a way to measure the income distribution of a population. The value for the Gini coefficient ranges from 0 to 1 where higher values represent greater income inequality and where: 0 represents perfect income equality (everyone has the same income) and 1 represents perfect income inequality (one individual has all the […]