Some time ago I demonstrated how to create Time-lapse animations in Excel in my post here. Part of that procedure utilized a short-lived but cool feature called ‘PowerView’. Unfortunately, as of late 2021, Microsoft has removed support for PowerView in Excel (that made this time-lapse animation possible) and instead is encouraging users to use PowerBI […]
Category: Analytics
How is chatGPT useful?
Author’s note: Instead of me explaining the benefits of ChatGPT, I figured why not let ChatGPT write its own summary and toot its own horn, and best of all write it straight into my blog site, creating a real blog post (without having me to copy/paste) and go live?! So, there we have it…this post […]
Decision Tree and Prediction (Python)
This is an example of a Decision Tree model (very useful and popular method) to make prediction using the power of Machine Learning…using just a normal PC. Here we predict salary (depedendent variable) by giving various types of criteria (different forks in a decision tree). e.g. What’s the salary of a particular gender, of some […]
What is Sigmoid function and why?
In this blog, I touch on a core function that’s used in many machine learning scenarios whether explicitly or as a part solving a given problem. This is extremely useful for recoding values for classification (binary or multiclass) where we need to map some categorical values into a finite range of values (e.g. 0 or […]
A Manifestation Formula
Will your dream come true? If so, how likely is it? What really is your desire composed of? And are there factors that affect that, if so, what are they; and which ones can we control? Following the search for answers to these questions, my ultimate quest was: Can we manufacture a formulation for quantifying […]
Mass and Energy – Explained Simply
In this blog, I explain in simple terms, the relationships between mass, weight, and ultimately energy as it relates to anything, including your own body mass, and how all of this can be tied to Einstein’s equation: E=MC^2. By the end of this post, you’ll be able to tell how much energy is stored within […]
Complementary post to: Pop Quiz [And Solutions With Low Code!]
This post is a continuation of or complementary post to about using Excel and SQL for pop-quizes. Please read that first to get proper context…otherwise, this wouldn’t make much sense. As discussed in the post linked above, the SQL queries can be saved from Microsoft Query Editor to an external file. It’s really convenient because […]
Pop Quiz [and Solutions with Low Code!]
Every now and then I see some simple quizzes pop-up on Facebook such as: “Name a state without letter A in it.” The letter can be another, they just switch it around from time to time. This particular post is inspired by such posts. Sure we can go through all the states in our heads […]
Carbon footprint estimation made easy
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 […]
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 […]