Analytics Education STEM

Animating Charts in Excel and beyond

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 […]

Read More
Analytics Coding Education STEM

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 […]

Read More
Coding STEM

Wanna be a weather reporter? Me neither! So let’s do Machine Learning (AI)! Part 2/2

This is a continuation of weather prediction via ML and is the final part (2/2) where I demonstrate how to write Python code to leverage a neural network algorithm called Neural Prophet, a quite straight-forward and useful model. Be sure to read the first part that focuses on understanding the data in Excel and some […]

Read More
Coding STEM

Wanna be a weather reporter? Me neither! So let’s do Machine Learning (AI)! Part 1/2

Reporting weather by reading off the predictions is obviously a very different skill than creating the code and models that actually predicts the weather! Not just forecasting for the next 5 days, but actually PREDICTING for any number of period in the future! Is that even possible? Yes, it is albeit there are myriad of […]

Read More
STEM

Logistic Regression Example (Excel, Python)

In my previous blog on Sigmoid function, I touched on its usefulness and how it’s used to solve Logistic Regression problems either in binary or multiclass classification scenarios. Be sure to check that out https://flyingsalmon.net/?p=3879 first! In this blog, we’ll be using a dataset containing people’s ages and whether or not they bought life insurance […]

Read More
STEM

Eiesenhower Matrix in Excel (Quadrant Matrix)

Former US President Eisenhower is known to have said: “What is important is seldom urgent and what is urgent is seldom important.” This is reflected in a popular quadrant design, often referred to as “The Eisenhower Matrix”, used to effectively prioritize tasks according to their urgency and importance. This can be expressed in a quadrant matrix (image) […]

Read More
Back To Top