Simple Explanation of Machine Learning shown with Excel – Part 2
Every wondered how Machine learning works? In this 2 part article we are going to explain machine learning with Excel. If you missed the first article and video you can read it here.
Iterations
Machine learning algorithms iterate the data over and over until it can establish the best route to take with the questions. Â For example, it will remove data where the entropy is 0 and re run the calculations to find the next question where entropy of 0 is found. Â Entropy of 0 on a decision tree is the final or decision leaf on a decision tree. Â If entropy of greater than 0 is found, the item with the most information gain is taken to be the next question and the iteration is re done on an amended data set depending on the answers. Looking at our sample data, in our first iteration, entropy is calculated on each classification and the data set. The first question is defined by the classification that gives the most information gain or if the entropy is 0. After this, any data with an entropy of 0 is removed, and then the algorithm can run again. Â The data that is removed is the data in which a decision can be made on. Â This will continue running and branching until the best decision tree route is defined. Entropy and information gain can be used to created decision trees from a top down approach. Â Below is the path chosen using the sample training data andPosted from my blog with SteemPress : http://theexcelclub.com/simple-explanation-of-machine-learning-shown-with-excel-part-2/
Thank you for the introduction to ML through decision trees, entropy, and information gain. I enjoyed the bank example.
you are most welcome, I am glad you liked it.
OK, I have to admit that I was disappointed there was no practice exercise. :-) I was so looking forward to working through a decision tree.
Do you have any other examples to recommend for working through a decision tree in Excel using the concepts you shared?
Hi @paulag ,
I want to ask you as an excell expert.
What would be the easy way (for noobs like me) to implement the SHA256 hashing function into a excel worksheet?
I want to do some tests and learning with crypto coin alghoritms .
Hashing is so powerfull functon, but i can not find way how to apply some automation . Got tired doing copy-paste all the time my data into dedicated applications.
Thanks.
PS
I am with the same nick name on Discord, Telegram, Slack, FB, Twitter
hi and thanks for the question.
for noobs its a little difficult as it would require a VBA code to be written. There is a sample here in this post that I found
https://superuser.com/questions/550592/is-there-an-excel-function-to-create-a-hash-value
Thanks.
I think I've seen this , but had a hopes there might be a more simple ways... :)
I always remember a joke of my professor which says:
There are two types of people in this world.
Does who understand iterations and does who understand iterations.
Posted using Partiko iOS
well lets hope this series helps explain iterations and also the part the play in machine learning. thanks for visiting
For sure...
People think that machine learning is kinda difficult to understand, however, when you fully understand the iterations everything becomes more easily to understand.
Cheers!