Tag: excel
-
The Machine Learning “Advent Calendar” Day 24: Transformers for Text in Excel
The Machine Learning “Advent Calendar” Day 24: Transformers for Text in Excel An intuitive, step-by-step look at how Transformers use self-attention to turn static word embeddings into contextual representations, illustrated with simple examples and an Excel-friendly walkthrough. The post The Machine Learning “Advent Calendar” Day 24: Transformers for Text in Excel appeared first on Towards…
-
The Machine Learning “Advent Calendar” Day 23: CNN in Excel
The Machine Learning “Advent Calendar” Day 23: CNN in Excel A step-by-step 1D CNN for text, built in Excel, where every filter, weight, and decision is fully visible. The post The Machine Learning “Advent Calendar” Day 23: CNN in Excel appeared first on Towards Data Science. angela shi Go to original source
-
The Machine Learning “Advent Calendar” Day 19: Bagging in Excel
The Machine Learning “Advent Calendar” Day 19: Bagging in Excel Understanding ensemble learning from first principles in Excel The post The Machine Learning “Advent Calendar” Day 19: Bagging in Excel appeared first on Towards Data Science. angela shi Go to original source
-
The Machine Learning “Advent Calendar” Day 14: Softmax Regression in Excel
The Machine Learning “Advent Calendar” Day 14: Softmax Regression in Excel Softmax Regression is simply Logistic Regression extended to multiple classes. By computing one linear score per class and normalizing them with Softmax, we obtain multiclass probabilities without changing the core logic. The loss, the gradients, and the optimization remain the same. Only the number…
-
The Machine Learning “Advent Calendar” Day 12: Logistic Regression in Excel
The Machine Learning “Advent Calendar” Day 12: Logistic Regression in Excel In this article, we rebuild Logistic Regression step by step directly in Excel. Starting from a binary dataset, we explore why linear regression struggles as a classifier, how the logistic function fixes these issues, and how log-loss naturally appears from the likelihood. With a…
-
The Machine Learning “Advent Calendar” Day 10: DBSCAN in Excel
The Machine Learning “Advent Calendar” Day 10: DBSCAN in Excel DBSCAN shows how far we can go with a very simple idea: count how many neighbors live close to each point. It finds clusters and marks anomalies without any probabilistic model, and it works beautifully in Excel. But because it relies on one fixed radius,…
-
The Machine Learning “Advent Calendar” Day 8: Isolation Forest in Excel
The Machine Learning “Advent Calendar” Day 8: Isolation Forest in Excel Isolation Forest may look technical, but its idea is simple: isolate points using random splits. If a point is isolated quickly, it is an anomaly; if it takes many splits, it is normal. Using the tiny dataset 1, 2, 3, 9, we can see…
-
The Machine Learning “Advent Calendar” Day 5: GMM in Excel
The Machine Learning “Advent Calendar” Day 5: GMM in Excel This article introduces the Gaussian Mixture Model as a natural extension of k-Means, by improving how distance is measured through variances and the Mahalanobis distance. Instead of assigning points to clusters with hard boundaries, GMM uses probabilities learned through the Expectation–Maximization algorithm – the general…
-
Understanding Convolutional Neural Networks (CNNs) Through Excel
Understanding Convolutional Neural Networks (CNNs) Through Excel Deep learning is often seen as a black box. We know that it learns from data, but we rarely stop to ask how it truly learns. What if we could open that box and watch each step happen right before our eyes? With Excel, we can do exactly…
-
Generating Data Dictionary for Excel Files Using OpenPyxl and AI Agents
Generating Data Dictionary for Excel Files Using OpenPyxl and AI Agents Introduction Every company I worked for until today, there it was: the resilient MS Excel. Excel was first released in 1985 and has remained strong until today. It has survived the rise of relational databases, the evolution of many programming languages, the Internet with…