Monday, December 15, 2025

The Machine Studying “Introduction Calendar” Day 11: Linear Regression in Excel


Linear Regression, lastly!

For Day 11, I waited many days to current this mannequin. It marks the start of a new journey on this “Introduction Calendar“.

Till now, we largely checked out fashions primarily based on distances, neighbors, or native density. As it’s possible you’ll know, for tabular information, resolution bushes, particularly ensembles of resolution bushes, are very performant.

However beginning right now, we swap to a different perspective: the weighted method.

Linear Regression is our first step into this world.
It seems easy, nevertheless it introduces the core elements of recent ML: loss features, gradients, optimization, scaling, collinearity, and interpretation of coefficients.

Now, after I say, Linear Regression, I imply Extraordinary Least Sq. Linear Regression. As we progress via this “Introduction Calendar” and discover associated fashions, you will note why you will need to specify this, as a result of the title “linear regression” might be complicated.

Some individuals say that Linear Regression is not machine studying.

Their argument is that machine studying is a “new” subject, whereas Linear Regression existed lengthy earlier than, so it can’t be thought of ML.

That is deceptive.
Linear Regression suits completely inside machine studying as a result of:

  • it learns parameters from information,
  • it minimizes a loss operate,
  • it makes predictions on new information.

In different phrases, Linear Regression is without doubt one of the oldest fashions, but in addition one of many most basic in machine studying.

That is the method utilized in:

  • Linear Regression,
  • Logistic Regression,
  • and, later, Neural Networks and LLMs.

For deep studying, this weighted, gradient-based method is the one that’s used in all places.

And in trendy LLMs, we’re now not speaking about just a few parameters. We’re speaking about billions of weights.

On this article, our Linear Regression mannequin has precisely 2 weights.

A slope and an intercept.

That’s all.

However now we have to start someplace, proper?

And listed below are just a few questions you possibly can bear in mind as we progress via this text, and within the ones to come back.

  • We’ll attempt to interpret the mannequin. With one function, y=ax+b, everybody is aware of {that a} is the slope and b is the intercept. However how can we interpret the coefficients the place there are 10, 100 or extra options?
  • Why is collinearity between options such an issue for linear regression? And the way can we do to unravel this situation?
  • Is scaling vital for linear regression?
  • Can Linear regression be overfitted?
  • And the way are the opposite fashions of this weighted familly (Logistic Regression, SVM, Neural Networks, Ridge, Lasso, and many others.), all related to the identical underlying concepts?

These questions type the thread of this text and can naturally lead us towards future subjects within the “Introduction Calendar”.

Understanding the Pattern line in Excel

Beginning with a Easy Dataset

Allow us to start with a quite simple dataset that I generated with one function.

Within the graph beneath, you possibly can see the function variable x on the horizontal axis and the goal variable y on the vertical axis.

The aim of Linear Regression is to seek out two numbers, a and b, such that we are able to write the connection:

y=a x +b

As soon as we all know a and b, this equation turns into our mannequin.

Linear regression in Excel – all photographs by writer

Creating the Pattern Line in Excel

In Google Sheets or Excel, you possibly can merely add a development line to visualise the perfect linear match.

That already provides you the results of Linear Regression.

Linear regression in Excel – all photographs by writer

However the goal of this text is to compute these coefficients ourselves.

If we need to use the mannequin to make predictions, we have to implement it straight.

Linear regression in Excel – all photographs by writer

Introducing Weights and the Value Perform

A Observe on Weight-Based mostly Fashions

That is the primary time within the Introduction Calendar that we introduce weights.

Fashions that study weights are sometimes referred to as parametric discriminant fashions.

Why discriminant?
As a result of they study a rule that straight separates or predicts, with out modeling how the info was generated.

Earlier than this chapter, we already noticed fashions that had parameters, however they weren’t discriminant, they had been generative.

Allow us to recap rapidly.

  • Resolution Bushes use splits, or guidelines, and so there aren’t any weights to study. So they’re non-parametric fashions.
  • k-NN isn’t a mannequin. It retains the entire dataset and makes use of distances at prediction time.

Nevertheless, once we transfer from Euclidean distance to Mahalanobis distance, one thing fascinating occurs…

LDA and QDA do estimate parameters:

  • means of every class
  • covariance matrices
  • priors

These are actual parameters, however they aren’t weights.
These fashions are generative as a result of they mannequin the density of every class, after which use it to make predictions.

So although they’re parametric, they don’t belong to the weight-based household.

And as you possibly can see, these are all classifiers, they usually estimate parameters for every class.

Linear regression in Excel – all photographs by writer

Linear Regression is our first instance of a mannequin that learns weights to construct a prediction.

That is the start of a brand new household within the Introduction Calendar:
fashions that depend on weights + a loss operate to make predictions.

The Value Perform

How can we acquire the parameters a and b?

Nicely, the optimum values for a and b are these minimizing the fee operate, which is the Squared Error of the mannequin.

So for every information level, we are able to calculate the Squared Error.

Squared Error = (prediction-real worth)²=(a*x+b-real worth)²

Then we are able to calculate the MSE, or Imply Squared Error.

As we are able to see in Excel, the trendline provides us the optimum coefficients. If you happen to manually change these values, even barely, the MSE will improve.

That is precisely what “optimum” means right here: another mixture of a and b makes the error worse.

Linear regression in Excel – all photographs by writer

The basic closed-form answer

Now that we all know what the mannequin is, and what it means to attenuate the squared error, we are able to lastly reply the important thing query:

How can we compute the 2 coefficients of Linear Regression, the slope a and the intercept b?

There are two methods to do it:

  • the precise algebraic answer, often known as the closed-form answer,
  • or gradient descent, which we’ll discover simply after.

If we take the definition of the MSE and differentiate it with respect to a and b, one thing stunning occurs: every part simplifies into two very compact formulation.

Linear regression in Excel – all photographs by writer

These formulation solely use:

  • the typical of x and y,
  • how x varies (its variance),
  • and the way x and y differ collectively (their covariance).

So even with out realizing any calculus, and with solely primary spreadsheet features, we are able to reproduce the precise answer utilized in statistics textbooks.

The way to interpret the coefficients

For one function, interpretation is easy and intuitive:

The slope a
It tells us how a lot y adjustments when x will increase by one unit.
If the slope is 1.2, it means:
“when x goes up by 1, the mannequin expects y to go up by about 1.2.”

The intercept b
It’s the predicted worth of y when x = 0.
Usually, x = 0 doesn’t exist in the actual context of the info, so the intercept isn’t at all times significant by itself.
Its function is usually to place the road appropriately to match the middle of the info.

That is normally how Linear Regression is taught:
a slope, an intercept, and a straight line.

With one function, interpretation is simple.

With two, nonetheless manageable.

However as quickly as we begin including many options, it turns into tougher.

Tomorrow, we’ll talk about additional concerning the interpretation.

Right this moment, we’ll do the gradient descent.

Gradient Descent, Step by Step

After seeing the basic algebraic answer for Linear Regression, we are able to now discover the opposite important device behind trendy machine studying: optimization.

The workhorse of optimization is Gradient Descent.

Understanding it on a quite simple instance makes the logic a lot clearer as soon as we apply it to Linear Regression.

A Light Heat-Up: Gradient Descent on a Single Variable

Earlier than implementing the gradient descent for the Linear Regression, we are able to first do it for a easy operate: (x-2)^2.

Everybody is aware of the minimal is at x=2.

However allow us to fake we have no idea that, and let the algorithm uncover it by itself.

The thought is to seek out the minimal of this operate utilizing the next course of:

  • First, we randomly select an preliminary worth.
  • Then for every step, we calculate the worth of the spinoff operate df (for this x worth): df(x)
  • And the subsequent worth of x is obtained by subtracting the worth of spinoff multiplied by a step dimension: x = x – step_size*df(x)

You may modify the 2 parameters of the gradient descent: the preliminary worth of x and the step dimension.

Sure, even with 100, or 1000. That’s fairly stunning to see, how effectively it really works.

Linear regression in Excel – all photographs by writer

However, in some instances, the gradient descent won’t work. For instance, if the step dimension is simply too huge, the x worth can explode.

Linear regression in Excel – all photographs by writer

Gradient descent for linear regression

The precept of the gradient descent algorithm is identical for linear regression: now we have to calculate the partial derivatives of the fee operate with respect to the parameters a and b. Let’s word them as da and db.

Squared Error = (prediction-real worth)²=(a*x+b-real worth)²

da=2(a*x+b-real worth)*x

db=2(a*x+b-real worth)

Linear regression in Excel – all photographs by writer

After which, we are able to do the updates of the coefficients.

Linear regression in Excel – all photographs by writer

With this tiny replace, step-by-step, the optimum worth might be discovered after just a few interations.

Within the following graph, you possibly can see how a and b converge in direction of the goal worth.

Linear regression in Excel – all photographs by writer

We are able to additionally see all the small print of y hat, residuals and the partial derivatives.

We are able to absolutely admire the fantastic thing about gradient descent, visualized in Excel.

For these two coefficients, we are able to observe how fast the convergence is.

Linear regression in Excel – all photographs by writer

Now, in apply, now we have many observations and this must be achieved for every information level. That’s the place issues turn out to be loopy in Google Sheet. So, we use solely 10 information factors.

You will note that I first created a sheet with lengthy formulation to calculate da and db, which comprise the sum of the derivatives of all of the observations. Then I created one other sheet to indicate all the small print.

Categorical Options in Linear Regression

Earlier than concluding, there’s one final vital concept to introduce:
how a weight-based mannequin like Linear Regression handles categorical options.

This matter is important as a result of it exhibits a basic distinction between the fashions we studied earlier (like k-NN) and the weighted fashions we’re getting into now.

Why distance-based fashions wrestle with classes

Within the first a part of this Introduction Calendar, we used distance-based fashions akin to Okay-NN, DBSCAN, and LOF.
However these fashions rely totally on measuring distances between factors.

For categorical options, this turns into unimaginable:

  • a class encoded as 0 or 1 has no quantitative which means
  • the numerical scale is bigoted,
  • Euclidean distance can’t seize class variations.

For this reason k-NN can’t deal with classes appropriately with out heavy preprocessing.

Weight-based fashions resolve the issue otherwise

Linear Regression doesn’t evaluate distances.
It learns weights.

To incorporate a categorical variable in a weight-based mannequin, we use one-hot encoding, the most typical method.

Every class turns into its personal function, and the mannequin merely learns one weight per class.

Why this works so effectively

As soon as encoded:

  • the dimensions drawback disappears (every part is 0 or 1),
  • every class receives an interpretable weight,
  • the mannequin can regulate its prediction relying on the group

A easy two-category instance

When there are solely two classes (0 and 1), the mannequin turns into very simple:

  • one worth is used when x=0,
  • one other when x=1.

One-hot encoding isn’t even essential:
the numeric encoding already works as a result of Linear Regression will study the suitable distinction between the 2 teams.

Gradient Descent nonetheless works

Even with categorical options, Gradient Descent works precisely as ordinary.

The algorithm solely manipulates numbers, so the replace guidelines for a and b are an identical.

Within the spreadsheet, you possibly can see the parameters converge easily, identical to with numerical information.

Nevertheless, on this particular two-category case, we additionally know {that a} closed-form system exists: Linear Regression primarily computes two group averages and the distinction between them.

Conclusion

Linear Regression might look easy, nevertheless it introduces virtually every part that trendy machine studying depends on.
With simply two parameters, a slope and an intercept, it teaches us:

  • tips on how to outline a value operate,
  • tips on how to discover optimum parameters, numerically,
  • and the way optimization behaves once we regulate studying charges or preliminary values.

The closed-form answer exhibits the magnificence of the arithmetic.
Gradient Descent exhibits the mechanics behind the scenes.
Collectively, they type the muse of the “weighted + loss operate” household that features Logistic Regression, SVM, Neural Networks, and even right now’s LLMs.

New Paths Forward

You might suppose Linear Regression is easy, however with its foundations now clear, you possibly can prolong it, refine it, and reinterpret it via many alternative views:

  • Change the loss operate
    Exchange squared error with logistic loss, hinge loss, or different features, and new fashions seem.
  • Transfer to classification
    Linear Regression itself can separate two lessons (0 and 1), however extra strong variations result in Logistic Regression and SVM. And what about multiclass classification?
  • Mannequin nonlinearity
    By polynomial options or kernels, linear fashions out of the blue turn out to be nonlinear within the authentic house.
  • Scale to many options
    Interpretation turns into more durable, regularization turns into important, and new numerical challenges seem.
  • Primal vs twin
    Linear fashions might be written in two methods. The primal view learns the weights straight. The twin view rewrites every part utilizing dot merchandise between information factors.
  • Perceive trendy ML
    Gradient Descent, and its variants, are the core of neural networks and enormous language fashions.
    What we realized right here with two parameters generalizes to billions.

Every little thing on this article stays throughout the boundaries of Linear Regression, but it prepares the bottom for a complete household of future fashions.
Day after day, the Introduction Calendar will present how all these concepts join.

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Articles