Indeed, “Climate change” has been the hot topic for the last couple of weeks. It even surpassed the hubbub around the pandemic the world is experiencing for the past 2 years and counting! Thanks to COP26…the gathering of the “relevant” world leaders to discuss top, pressing issues of the world, the list of which contains […]
Category: Analytics
Ig Nobel Prize Winners: 2021
The winners of the 2021 Ig Nobel Prize are announced today. One of them caught my attention, which happens to be in the Economics category by Pavlo Blavatskyy for for discovering that the obesity of a country’s politicians may be a good indicator of that country’s corruption. Very interesting indeed and although it made me […]
Potential Sculpture Designs
Here’s a quick scratch pad note about a couple of shapes (one is hyperbolic paraboloid and another one has no name…will have to come up with an artificial one!)…playing with the equations a+b+c=bc and a+b+c=abc Their shapes are mesmerizing to me and in addition to them being artistic, cool, I also see practical uses of […]
Site discovery: Compare places in many ways
I recently stumbled upon this site while looking up some stats on a specific country and wanted to also compare them with another country. The site is MyLifeElseWhere and I have been quite impressed by its simplicity, usefulness and user-interface; so much so that I think I should share this with others although I have […]
Safe disposal of 6-pack rings killers
The six-pack yokes or rings are a set of connected plastic rings that are used in multi-packs of beverage and beer cans in the USA. These are discarded carelessly by most Americans and even though you might put them in recycle cans (if your city has the facility like mine does), they somehow end up […]
Project Management Mind Map
Here’s a ‘simple’ e2e SW Project Management Mind Map I created for a quick checklist of major items to keep in mind. Enjoy! Click on See the board button below to access the chart. Then you can use left mouse button to drag, wheel to zoom, or use the controls in the UI to see […]
Raw Data to Machine Learning to Decision-Tree: step-by-step
Machine Learning in Excel? Isn’t ML the new thing, new algorithm that’s only done in the Cloud using R and Python? Nope! We’ve been doing in Excel for many years!! It’s only recently getting a lot of attention with Cloud and large datasets and made much, much simpler to use for today’s Data Scientists— but […]
Did your promotion work?
In an earlier blog How Well Are Your Incentives Working? I shared methods on how to calculate the various chances of success based on some campaign data (e.g. new sign-ups for membership) from various trials using Binomial distribution. In this post, I show how to determine if events occurred due to random chance or affected […]
Waffle Charts (3 methods + bonus)
You may heard of “waffle” charts. They’re usually depicted with little blocks in a larger area to give an easy view of proportions. The idea is not any different from a pie chart, or an area chart, or even a treemap…it all depends on your audience and preference. However, it’s suitable for small number of […]
Counting words/elements correctly in Excel
In some of my previous posts, you’ve already seen my Python examples on how to count words accurately in a document or in blocks of text (search for: Wordcloud). It’s also possible to count the words in Excel, but we have some gotchas there to be aware of. In this blog, I demonstrate some of […]