Close Menu
    Facebook LinkedIn YouTube WhatsApp X (Twitter) Pinterest
    Trending
    • These Were My Favorite Things Samsung Unpacked During Its 2026 Galaxy Event
    • AI minister role boosted but tech department axed in Burnham shake-up
    • Loop Engineering for RAG Question Parsing: The Small Loop That Runs Before Retrieval
    • The risk of weather data sabotage is rising
    • Hand-E Now Reaches 100 mm Without Giving Up an Ounce of Precision
    • Weight loss drug effectiveness and long term maintenance
    • Here’s what Albo’s ‘Office of AI’ means for Australian tech
    • YouTube and X Have Become ‘Gateways’ to Nudify Apps
    Facebook LinkedIn WhatsApp
    Times FeaturedTimes Featured
    Thursday, July 23
    • Home
    • Founders
    • Startups
    • Technology
    • Profiles
    • Entrepreneurs
    • Leaders
    • Students
    • VC Funds
    • More
      • AI
      • Robotics
      • Industries
      • Global
    Times FeaturedTimes Featured
    Home»Artificial Intelligence»The Machine Learning “Advent Calendar” Day 14: Softmax Regression in Excel
    Artificial Intelligence

    The Machine Learning “Advent Calendar” Day 14: Softmax Regression in Excel

    Editor Times FeaturedBy Editor Times FeaturedDecember 14, 2025No Comments8 Mins Read
    Facebook Twitter Pinterest Telegram LinkedIn Tumblr WhatsApp Email
    Share
    Facebook Twitter LinkedIn Pinterest Telegram Email WhatsApp Copy Link


    With Logistic Regression, we discovered the right way to classify into two courses.

    Now, what occurs if there are greater than two courses.

    n is just the multiclass extension of this concept. And we’ll focus on this mannequin for Day 14 of my Machine Learning “Advent Calendar” (observe this hyperlink to get all of the details about the strategy and the recordsdata I exploit).

    As a substitute of 1 rating, we now create one rating per class. As a substitute of 1 chance, we apply the Softmax perform to provide possibilities that sum to 1.

    Understanding the Softmax mannequin

    Earlier than coaching the mannequin, allow us to first perceive what the mannequin is.

    Softmax Regression just isn’t about optimization but.
    It’s first about how predictions are computed.

    A tiny dataset with 3 courses

    Allow us to use a small dataset with one characteristic x and three courses.

    As we stated earlier than, the goal variable y ought to not be handled as numerical.
    It represents classes, not portions.

    A typical option to characterize that is one-hot encoding, the place every class is represented by its personal indicator.

    From this viewpoint, Softmax Regression could be seen as three Logistic Regressions operating in parallel, one per class.

    Small datasets are perfect for studying.
    You possibly can see each formulation, each worth, and the way every a part of the mannequin contributes to the ultimate outcome.

    Softmax regression in Excel – All photos by creator

    Description of the Mannequin

    So what’s the mannequin, precisely?

    Rating per class

    In logistic regression, the mannequin rating is a straightforward linear expression: rating = a * x + b.

    Softmax Regression does precisely the identical, however one rating per class:

    score_0 = a0 * x + b0
    score_1 = a1 * x + b1
    score_2 = a2 * x + b2

    At this stage, these scores are simply actual numbers.
    They aren’t possibilities but.

    Turning scores into possibilities: the Softmax step

    Softmax converts the three scores into three possibilities. Every chance is optimistic, and all three sum to 1.

    The computation is direct:

    1. Exponentiate every rating
    2. Compute the sum of all exponentials
    3. Divide every exponential by this sum

    This offers us p0, p1, and p2 for every row.

    These values characterize the mannequin confidence for every class.

    At this level, the mannequin is totally outlined.
    Coaching the mannequin will merely consist in adjusting the coefficients ak​ and bk​ in order that these possibilities match the noticed courses in addition to attainable.

    Softmax regression in Excel – All photos by creator

    Visualizing the Softmax mannequin

    At this level, the mannequin is totally outlined.

    We’ve:

    • one linear rating per class
    • a Softmax step that turns these scores into possibilities

    Coaching the mannequin merely consists in adjusting the coefficients aka_kak​ and bkb_kbk​ in order that these possibilities match the noticed courses in addition to attainable.

    As soon as the coefficients have been discovered, we will visualize the mannequin habits.

    To do that, we take a spread of enter values, for instance x from 0 to 7, and we compute: score0,score1,score2 and the corresponding possibilities p0,p1,p2.

    Plotting these possibilities offers three easy curves, one per class.

    Softmax regression in Excel – All photos by creator

    The outcome could be very intuitive.

    For small values of x, the chance of sophistication 0 is excessive.
    As x will increase, this chance decreases, whereas the chance of sophistication 1 will increase.
    For bigger values of x, the chance of sophistication 2 turns into dominant.

    At each worth of x, the three possibilities sum to 1.
    The mannequin doesn’t make abrupt selections; as a substitute, it expresses how assured it’s in every class.

    This plot makes the habits of Softmax Regression straightforward to know.

    • You possibly can see how the mannequin transitions easily from one class to a different
    • Choice boundaries correspond to intersections between chance curves
    • The mannequin logic turns into seen, not summary

    This is likely one of the key advantages of constructing the mannequin in Excel:
    you don’t simply compute predictions, you’ll be able to see how the mannequin thinks.

    Now that the mannequin is outlined, we’d like a option to consider how good it’s, and a way to enhance its coefficients.

    Each steps reuse concepts we already noticed with Logistic Regression.

    Evaluating the mannequin: Cross-Entropy Loss

    Softmax Regression makes use of the similar loss perform as Logistic Regression.

    For every knowledge level, we take a look at the chance assigned to the right class, and we take the detrimental logarithm:

    loss = – log (p true class)

    If the mannequin assigns a excessive chance to the proper class, the loss is small.
    If it assigns a low chance, the loss turns into massive.

    In Excel, that is quite simple to implement.

    We choose the proper chance based mostly on the worth of y, and apply the logarithm:

    loss = -LN( CHOOSE(y + 1, p0, p1, p2) )

    Lastly, we compute the common loss over all rows.
    This common loss is the amount we need to decrease.

    Softmax regression in Excel – All photos by creator

    Computing residuals

    To replace the coefficients, we begin by computing residuals, one per class.

    For every row:

    • residual_0 = p0 minus 1 if y equals 0, in any other case 0
    • residual_1 = p1 minus 1 if y equals 1, in any other case 0
    • residual_2 = p2 minus 1 if y equals 2, in any other case 0

    In different phrases, for the proper class, we subtract 1.
    For the opposite courses, we subtract 0.

    These residuals measure how far the expected possibilities are from what we count on.

    Computing the gradients

    The gradients are obtained by combining the residuals with the characteristic values.

    For every class okay:

    • the gradient of ak is the common of residual_k * x
    • the gradient of bk is the common of residual_k

    In Excel, that is applied with easy formulation comparable to SUMPRODUCT and AVERAGE.

    At this level, every thing is specific:
    you see the residuals, the gradients, and the way every knowledge level contributes.

    Screenshot

    Updating the coefficients

    As soon as the gradients are recognized, we replace the coefficients utilizing gradient descent.

    This step is an identical as we noticed earlier than, fore Logistic Regression or Linear regression.
    The one distinction is that we now replace six coefficients as a substitute of two.

    To visualise studying, we create a second sheet with one row per iteration:

    • the present iteration quantity
    • the six coefficients (a0, b0, a1, b1, a2, b2)
    • the loss
    • the gradients

    Row 2 corresponds to iteration 0, with the preliminary coefficients.

    Row 3 computes the up to date coefficients utilizing the gradients from row 2.

    By dragging the formulation down for a whole bunch of rows, we simulate gradient descent over many iterations.

    You possibly can then clearly see:

    • the coefficients steadily stabilizing
    • the loss lowering iteration after iteration

    This makes the training course of tangible.
    As a substitute of imagining an optimizer, you’ll be able to watch the mannequin be taught.

    Logistic Regression as a Particular Case of Softmax Regression

    Logistic Regression and Softmax Regression are sometimes offered as completely different fashions.

    In actuality, they’re the identical concept at completely different scales.

    Softmax Regression computes one linear rating per class and turns these scores into possibilities by evaluating them.
    When there are solely two courses, this comparability relies upon solely on the distinction between the 2 scores.

    This distinction is a linear perform of the enter, and making use of Softmax on this case produces precisely the logistic (sigmoid) perform.

    In different phrases, Logistic Regression is just Softmax Regression utilized to 2 courses, with redundant parameters eliminated.

    As soon as that is understood, shifting from binary to multiclass classification turns into a pure extension, not a conceptual bounce.

    Softmax Regression doesn’t introduce a brand new mind-set.

    It merely reveals that Logistic Regression already contained every thing we would have liked.

    By duplicating the linear rating as soon as per class and normalizing them with Softmax, we transfer from binary selections to multiclass possibilities with out altering the underlying logic.

    The loss is similar concept.
    The gradients are the identical construction.
    The optimization is similar gradient descent we already know.

    What modifications is barely the variety of parallel scores.

    One other Technique to Deal with Multiclass Classification?

    Softmax just isn’t the one option to take care of multiclass issues in weight-based fashions.

    There’s one other strategy, much less elegant conceptually, however quite common in follow:
    one-vs-rest or one-vs-one classification.

    As a substitute of constructing a single multiclass mannequin, we practice a number of binary fashions and mix their outcomes.
    This technique is used extensively with Help Vector Machines.

    Tomorrow, we’ll take a look at SVM.
    And you will notice that it may be defined in a somewhat uncommon manner… and, as standard, straight in Excel.



    Source link

    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email
    Editor Times Featured
    • Website

    Related Posts

    Loop Engineering for RAG Question Parsing: The Small Loop That Runs Before Retrieval

    July 19, 2026

    How to Find the Optimal Coding Agent Interface

    July 9, 2026

    I Completed Five Years in Analytics Consulting: 5 Lessons That Changed How I Work

    June 29, 2026

    GPU-Resident Top-K for Agentic RAG: I Built a CUDA Kernel So My Retrieval Step Would Stop Bouncing Off the GPU

    June 19, 2026

    Can Machine Learning Predict the World Cup?

    June 9, 2026

    Automate Writing Your LLM Prompts

    June 5, 2026

    Comments are closed.

    Editors Picks

    These Were My Favorite Things Samsung Unpacked During Its 2026 Galaxy Event

    July 22, 2026

    AI minister role boosted but tech department axed in Burnham shake-up

    July 21, 2026

    Loop Engineering for RAG Question Parsing: The Small Loop That Runs Before Retrieval

    July 19, 2026

    The risk of weather data sabotage is rising

    July 18, 2026
    Categories
    • Founders
    • Startups
    • Technology
    • Profiles
    • Entrepreneurs
    • Leaders
    • Students
    • VC Funds
    About Us
    About Us

    Welcome to Times Featured, an AI-driven entrepreneurship growth engine that is transforming the future of work, bridging the digital divide and encouraging younger community inclusion in the 4th Industrial Revolution, and nurturing new market leaders.

    Empowering the growth of profiles, leaders, entrepreneurs businesses, and startups on international landscape.

    Asia-Middle East-Europe-North America-Australia-Africa

    Facebook LinkedIn WhatsApp
    Featured Picks

    Thousands of UK customers report broadband issues

    October 14, 2025

    Reinforcement Learning Made Simple: Build a Q-Learning Agent in Python

    May 28, 2025

    Expert panel will determine AGI arrival in new Microsoft-OpenAI agreement

    November 3, 2025
    Categories
    • Founders
    • Startups
    • Technology
    • Profiles
    • Entrepreneurs
    • Leaders
    • Students
    • VC Funds
    Copyright © 2024 Timesfeatured.com IP Limited. All Rights.
    • Privacy Policy
    • Disclaimer
    • Terms and Conditions
    • About us
    • Contact us

    Type above and press Enter to search. Press Esc to cancel.