As was previously mentioned (GAT) python, matlab, and R are all great alternatives to Excel for this type of analysis. If you can learn and utilize any of them, you'll seldom find reason to go back to Excel for modelling.
1) Many ways to do this. Pretty much the goal of statistical modelling...