I tried to research what exactly is a SOLVER only to find a not clear-cut simple answer. My doubts still remain after going through several sites full of discussions about it.
I need to clarify as to whether it is a software product, or is it an open-source tool, or is it a commercial software package? Or is it like a library package that one can even design his/her own?
All I could find is that people related "solver" to Microsoft Excel or advanced Excel, and there were sources quoting a solver in connection to various programming languages like python, java, C#. I even saw the term's usage with HADOOP.
If it happens to be a software package, then, is there any other package comparable to it or better than it, which can perform a wider range of tasks(for statistics) than "solver"?