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 http://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
STEM

HOW TO CREATE AN ORGANIZATIONAL CHART FROM EXCEL DATA

If you’ve worked with Visio or PowerPoint, you may have used their built-in organizational charts…and manually enter the information for each node. But what if you have the data already as a table, as in a CSV or Excel file? You can use that data and create an organizaitonal chart right within Excel. However, you’ll […]

Read More
Back To Top