Basic Neural Network in Excel

Constructing a basic back-propagation algorithm in microsoft excel. File available for download:
Link: predictivemodeler.com/2018/12...

[@MrAlipatik]

Thank you

[@prasadsanap8422]

Great Explanation!

[@predictivemodeler]

Thank you!

[@thezorrinofromgemail6978]

Great explation. Where is the next youtube that must improve the model as you indicate it at the end ? And where is the file to download ? Thanks a lot.

[@doddyardana2147]

How to make prediction equation with several input neuron in artificial neural network?Can we use the bias value, weight from ANN with MAtlab analysis?

[@EnsariYILDIRIM]

Tanh or sigmoid functions are very useful for binary output problems. Well, in case of a polinomial output, which activation function do you supposed to use?

[@greenief9097]

You can use the same activation functions for outputs greater than 2. The activation function will essentially turn on or off for each potential output in the list of possible outputs

[@namyam3840]

Thank you sir! great explanation . . but would you explain me something about the Tanh(a) and Tanh(b) functions, why and how are they initialized to 1.72 and 0.67 respectively ? Is it must to initialize it? If yes, how?

[@predictivemodeler]

Thanks! The short answer is that it is a heurisitic choice. This choice is discussed in a paper by LeCun, "Generalization and Network Design", 1989. It has to do with making the equations a little simpler, and the overall second derivative of the hyperbolic function is a pleasing (well, to some!) +1 to -1. This choice is thought to improve convergence of the learning process.

[@jegatheshwaran1971]

Can you pls provide the idea for preparation excel for preceptron neural networks

[@predictivemodeler]

Not sure I understood the question, can you elaborate?

[@carlosmerino6554]

Is the file available?