Jeremy Lane

Mathematics and Statistics Hacks for Excel VBA Jeremy Lane

This text addresses the need for people who are attempting to gain a familiarity with Excel VBA programming to help them in academics or professional careers by offering more than 300 subroutines and functions for mathematical and statistical calculations. Algorithms span many topics in mathematics, beginning with introductory algebra and continuing through calculus, linear algebra and differential equations. Included in this text are algorithms for polynomial theory, double and triple integrals, matrix decompositions, and finite difference methods. Also available are algorithms for Minisum Method, phase portraits and slope fields, cobweb diagrams, Rossmo's geographic profile algorithm and many more.