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 […]
Tag: education
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 […]
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 […]
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 […]
Conditional Formatting Presentation (Excel)
Microsoft Quarterly Report was publicly released on April 25, 2024. It has tabulated data on year over year percent change in revenues by Microsoft fiscal quarter (Q1 is from July 1 through September 30). I tabulated the data from fiscal year 2023 Q1 through Q4, and from fiscal year 2024 Q1 through Q3 (Q4 data […]
Dumbbell Chart (Excel)
Dumbbell chart, aka Connected Dot plot is a type of chart that’s suitable for visually comparing values especially between two periods or showcase change. In this post, I demonstrate its usefulness as well some key steps on how to create one in Microsoft Excel (Office 365). Let’s start with the data. I have some data […]
An interactive musical keyboard player (Python)
In this post, I am sharing my Python code for creating a simple musical keyboard player that can be played using a standard computer keyboard. The app will generate specific musical notes as you press keys A-Z on your keyboard. You can increase a note by half-step or full-step by each press. So, increasing by […]
How to make a perfect birthday cake in Excel
I’ve been exploring whether it’s possible to create a birthday cake-style chart in Excel. After some adjustments, I’ve reached a point where I can confidently say it’s achievable! You may ask, why not simply download an image from the internet? Well, that’s less engaging, potentially unlawful, and above all, it lacks the customization and scalability […]
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]