Close Menu
    Facebook LinkedIn YouTube WhatsApp X (Twitter) Pinterest
    Trending
    • Robots-Blog | Humanoide Robotik aus Deutschland: igus bringt neuen Serviceroboter auf den Markt
    • GM reimagines Hummer off-roader with California ideas unit
    • London’s DEScycle secures over €10 million in grant funding to scale critical metals recovery platform
    • How to Edit, Merge, and Split PDFs With Free Online Tools
    • Florida crackdown targets illegal machines in Sarasota
    • Audiophile-Oriented Noble Audio Debuts More Affordable Osprey Earbuds
    • New radio bursts detected from binary stars
    • Remarkable, Catalysr and Indigenous pre-accelerators score NSW government support for diverse founders
    Facebook LinkedIn WhatsApp
    Times FeaturedTimes Featured
    Tuesday, June 2
    • 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 17: Neural Network Regressor in Excel
    Artificial Intelligence

    The Machine Learning “Advent Calendar” Day 17: Neural Network Regressor in Excel

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


    are sometimes introduced as black packing containers.

    Layers, activations, gradients, backpropagation… it might probably really feel overwhelming, particularly when every little thing is hidden behind mannequin.match().

    We’ll construct a neural community regressor from scratch utilizing Excel. Each computation will probably be specific. Each intermediate worth will probably be seen. Nothing will probably be hidden.

    By the tip of this text, you’ll perceive how a neural community performs regression, how ahead propagation works, and the way the mannequin can approximate non-linear features utilizing only a few parameters.

    Earlier than beginning, in case you have not already learn my earlier articles, it is best to first have a look at the implementation of linear regression and logistic regression.

    You will note {that a} neural community isn’t a brand new object. It’s a pure extension of those fashions.

    As regular, we are going to observe these steps:

    • First, we are going to have a look at how the mannequin of a Neural Community Regressor works. Within the case of neural networks, this step is known as ahead propagation.
    • Then we are going to practice this operate utilizing gradient descent. This course of is known as backpropagation.

    1. Ahead propagation

    On this half, we are going to outline our mannequin, then implement it in Excel to see how the prediction works.

    1.1 A Easy Dataset

    We’ll use a quite simple dataset that I generated. It consists of simply 12 observations and a single characteristic.

    As you possibly can see, the goal variable has a nonlinear relationship with x.

    And for this dataset, we are going to use two neurons within the hidden layer.

    1.2 Neural Community Construction

    Our instance neural community has:

    • One enter layer with the characteristic x as enter
    • One hidden layer with two neurons within the hidden layer, and these two neurons will enable us to create a nonlinear relationship
    • The output layer is only a linear regression

    Right here is the diagram that represents this neural community, together with all of the parameters that should be estimated. There are a complete of seven parameters.

    Hidden layer:

    • a11​: weight from x to hidden neuron 1
    • b11​: bias of hidden neuron 1
    • a12​: weight from x to hidden neuron 2
    • b12​: bias of hidden neuron 2

    Output layer:

    • a2​1: weight from hidden neuron 1 to output
    • a22​: weight from hidden neuron 2 to output
    • b2​: output bias

    At its core, a neural community is only a operate. A composed operate.

    In case you write it explicitly, there may be nothing mysterious about it.

    We normally symbolize this operate with a diagram product of “neurons”.

    For my part, one of the best ways to interpret this diagram is as a visible illustration of a composed mathematical operate, not as a declare that it actually reproduces how organic neurons work.

    Why does this operate work?

    Every sigmoid behaves like a clean step.
    With two sigmoids, the mannequin can improve, lower, bend, and flatten the output curve.

    By combining them linearly, the community can approximate clean non-linear curves.

    Because of this for this dataset, two neurons are already sufficient. However would you have the ability to discover a dataset for which this construction isn’t appropriate?

    1.3 Implementation of the operate in Excel

    On this part, we are going to suppose that the 7 coefficients are already discovered. And we will then implement the method we noticed simply earlier than.

    To visualise the neural community, we will use new steady values of x starting from -2 to 2 with a step of 0.02.

    Right here is the screenshot, and we will see that the ultimate operate matches the form of the enter information fairly effectively.

    2. Backpropagation (Gradient descent)

    At this level, the mannequin is totally outlined.

    Since it’s a regression downside, we are going to use the MSE (imply squared error), similar to for a linear regression.

    Now, now we have to search out the 7 parameters that reduce the MSE.

    2.1 Particulars of the backpropagation algorithm

    The precept is easy. BUT, since there are various composed features and plenty of parameters, now we have to be organized with the derivatives.

    I cannot derive all of the 7 partial derivatives explicitly. I’ll simply give the outcomes.

    As we will see, there may be the error time period. So with a purpose to implement the entire course of, now we have to observe this loop:

    1. initialize the weights,
    2. compute the output (ahead propagation),
    3. compute the error,
    4. compute gradients utilizing partial derivatives,
    5. replace the weights,
    6. repeat till convergence.

    2.2 Initialization

    Let’s get began by placing the enter dataset in a column format, which can make it simpler to implement the formulation in Excel.

    In idea, we will start with random values for the initialization of the values of the parameters. However in apply, the variety of iterations may be massive to realize full convergence. And because the value operate isn’t convex, we will get caught in a neighborhood minimal.

    So now we have to decide on “correctly” the preliminary values. I’ve ready some for you. You can also make small modifications to see what occurs.

    2.3 Ahead propagation

    Within the columns from AG to BP, we carry out the ahead propagation section. We compute A1 and A2 first, adopted by the output. These are the identical formulation used within the earlier a part of the ahead propagation.

    To simplify the computations and make them extra manageable, we carry out the calculations for every commentary individually. This implies now we have 12 columns for every hidden layer (A1 and A2) and the output layer. As a substitute of utilizing a summation method, we calculate the values for every commentary individually.

    To facilitate the for loop course of throughout the gradient descent section, we set up the coaching dataset in columns, and we will then prolong the method in Excel by row.

    2.4 Errors and the Price operate

    In columns BQ to CN, we will now compute the values of the fee operate.

    2.5 Partial derivatives

    We will probably be computing 7 partial derivatives equivalent to the weights of our neural community. For every of those partial derivatives, we might want to compute the values for all 12 observations, leading to a complete of 84 columns. Nonetheless, now we have made efforts to simplify this course of by organizing the sheet with coloration coding and formulation for ease of use.

    So we are going to start with the output layer, for the parameters: a21, a22 and b2. We will discover them within the columns from CO to DX.

    Then for the parameters a11 and a12, we will discover them from columns DY to EV:

    And at last, for the bias parameters b11 and b12, we use columns EW to FT.

    And to wrap it up, we sum all of the partial derivatives throughout the 12 observations. These aggregated gradients are neatly organized in columns Z to AF. The parameter updates are then carried out in columns R to X, utilizing these values.

    2.6 Visualization of the convergence

    To raised perceive the coaching course of, we visualize how the parameters evolve throughout gradient descent utilizing a graph. On the identical time, the lower of the fee operate is tracked in column Y, making the convergence of the mannequin clearly seen.

    Conclusion

    A neural community regressor isn’t magic.

    It’s merely a composition of elementary features, managed by a sure variety of parameters and skilled by minimizing a well-defined mathematical goal.

    By constructing the mannequin explicitly in Excel, each step turns into seen. Ahead propagation, error computation, partial derivatives, and parameter updates are now not summary ideas, however concrete calculations you could examine and modify.

    The total implementation of our neural community, from ahead propagation to backpropagation, is now full. You’re inspired to experiment by altering the dataset, the preliminary parameter values, or the educational price, and observe how the mannequin behaves throughout coaching.

    By means of this hands-on train, now we have seen how gradients drive studying, how parameters are up to date iteratively, and the way a neural community progressively shapes itself to suit the info. That is precisely what occurs inside trendy machine studying libraries, solely hidden behind just a few traces of code.

    When you perceive it this fashion, neural networks cease being black packing containers.



    Source link

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

    Related Posts

    Escaping the Valley of Choice in BI

    June 2, 2026

    Ensuring Data Integrity with Cryptographic Hashing and the Ethereum Blockchain

    June 1, 2026

    RAG Is Not Machine Learning, and the ML Toolkit Solves the Wrong Problem

    June 1, 2026

    How to Combine Claude Code and Codex for Maximum Coding Power

    June 1, 2026

    It’s the Lessons We Learned Along the Way. Or, Is It?

    June 1, 2026

    Proxy-Pointer RAG: Eliminating Wasteful Entity & Relations Extraction in Knowledge Graphs

    May 31, 2026

    Comments are closed.

    Editors Picks

    Robots-Blog | Humanoide Robotik aus Deutschland: igus bringt neuen Serviceroboter auf den Markt

    June 2, 2026

    GM reimagines Hummer off-roader with California ideas unit

    June 2, 2026

    London’s DEScycle secures over €10 million in grant funding to scale critical metals recovery platform

    June 2, 2026

    How to Edit, Merge, and Split PDFs With Free Online Tools

    June 2, 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

    Limited edition titanium vise with unique features

    September 29, 2025

    The EU-Startups Podcast | Interview with Ryan Luke Johns, Co-founder & CEO of Gravis Robotics

    January 19, 2026

    Penn Entertainment adds three directors after deal with HG Vora Capital

    February 25, 2026
    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.