ANN (Artificial Neural Network) is a machine learning algorithm.
And it does not come as standard in Excel. You'll either need to create your own model or write a code. Alternately... integrate R or Python packages into Excel (though there may be other ways).
Update: I had missed the most recent article by Chandoo. It's the topic that you'll want to look at. It's easier to follow than the article I posted before. Though algorithm used is different, concept is much the same.
Was that simple for you? since that went over my head.
It has too many things going on with too many countries which is confusing, despite impressive..
Even the code is confusing.
But a simpler input would have been a better example with a long list of binary or just numbers.
He has some references in the download example excel file which ok but still lost.
Thanks
Thanks. It is smaller to get a better grasp but still not so simple for me despite easy for you and probably others.
The node is a cool idea how its done with 1/0 the rest got too technical and limited.
Plenty of columns do not have a explanation in why iy does iy and I seem to get errors on 2nd tab..
I just changed the input to have 3 digit numbers and specify if it was higher than 4 individually. narrowed down the rows to 700 to upload.
but still i dont see it predicting and it just shows a jumble of numbers.
not as simple as plug and play to input numbers and it predicts a degree of what will come.