Ms Excel Full [portable] — Build Neural Network With
Building a neural network from scratch in Microsoft Excel is possible using core spreadsheet formulas for Forward Propagation Backpropagation Towards AI The architecture for a simple network consists of an Input Layer (your features), a Hidden Layer (where features are combined), and an Output Layer (your final prediction). Towards Data Science 1. Initialize Weights and Biases
- Hidden to Output Layer:
=Hidden_Output_1*W2_1+Hidden_Output_2*W2_2+B2 - Activation (Sigmoid):
=1/(1+EXP(-(Output_Input)))
2. Hidden Bias (b1)
- It started at 0.53.
- It drifted to 0.48.
- Then 0.21.
- Then, miraculously, it began to hover near 0.00 for the (0,0) inputs.
- Input Layer (The Data): This is simply your raw data columns (e.g., Sepal Length, Petal Width for the Iris dataset).
- Hidden Layers (The Complexity): Unlike a simple regression, a "full" build features at least one hidden layer.