Home > Excel > Mathematics


Equation Solver  
Excel's Goal Seek under the Tools menu is a very powerful equation solver. It can solve sets of equations spread out in various cells as shown in this example page.
Submitted: Sep 28, 1999
Excel in Finite Mathematics and Calculus  
Complete sets of Excel projects and tutorials for use in a college course in finite mathematics and calculus available for free download. Also available is a guide to Excel published by Houghton-Mifflin.
Submitted: Oct 01, 2001
MATRIX 1.0  
This Excel 97/2000 addin contains useful functions for matrix and linear algebra and solving linear systems. This includes operations such as euclidean norm ,matrix operations, similarity transforms, determinant, and inverse. All functions work in standard 32 bit precision. Help on line with freeware and open source. For math fans!
Submitted: Sep 12, 1999
Applied Mathematics Models for Excel  
Financial-edu.com (www.financial-edu.com) offers a complete package of applied mathematics forecasting and neural network tools for Excel. Multiple and Individual Regression of independent variables, tests for statistical significance, auto-correlation, and multi-colinearity, forecasting with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines, auto-learning, pattern recognition, and more! Use our tools for economic analysis, corporate cost/revenue forecasting, stock price prediction, sports scores, behavioral analysis – the uses are endless!
Submitted: Oct 12, 2004
XLMathematics is a set of Excel 5 workbooks for doing mathematical computations. There are many graphing routines, workbooks for linear algebra, workbooks for calculus...
Submitted: Sep 02, 1999
This suite of Excel add-ins for quantitative analysis, along with its accompanying tutorial documentation, provides Monte Carlo simulation, decision trees, queuing simulations, optimization, Markov chains, and forecasting.
Submitted: Aug 05, 1999
Mathematica Link for Excel  
By adding Mathematica into your Excel platform, you can manipulate and visualize data and equations with over a thousand more functions and options. It's easy to send even large data sets from Excel to Mathematica for the kind of sophisticated analysis Excel can't do alone, and then to return the results right into your spreadsheet.
Submitted: Sep 07, 1999
Premium Solver  
The Premium Solver is an upwardly compatible extension of the standard Excel Solver, with the capacity to solve much larger problems -- up to 2,000 variables, at speeds anywhere from three to 100 times faster than the standard Solver. It also includes an Evolutionary Solver you can use to solve non-linear, non-smooth models using any Excel formulas and functions.
Submitted: Sep 02, 1999
SimQuick is an Excel spreadsheet that allows the user to model simple processes: waiting lines (e.g., banks, fast-food restaurants, call centers); inventory and supply chains (e.g., stores, warehouses, and simple combinations of these); manufacturing (e.g., assembly lines, batch processes, simple job shops); and projects with uncertain task times. SimQuick is accompanied by a 100 page booklet that introduces the technique of process simulation through realistic examples and exercises that utilize SimQuick.
Spreadsheets in Education  
This page tries to collect some information about spreadsheets with an emphasis on mathematics and statistics education.
Submitted: Sep 02, 1999
Class Math Expression Parser. v. 3.0 by Leonardo Volpi, Michael Ruder, Thomas Zeutschler, Lieven Dossche. A nice class for parsing and evaluating math expressions in Visual Basic 6 and VBA 97/2000. Exponential (1.23E-3) and physical numbers with unit of measure like m, MHz, ms, Kg, etc. are recognized. Functions and operators: Abs Atn Cos Exp Fix Int Ln Log Rnd Sgn Sin Sqr Tan Acos Asin Cosh Sinh Tanh Acosh Asinh Atanh Fact Comb Max Min Mcm Mcd Mod And Or Not Xor Erf Gamma Gammaln Digamma Zeta Ei + - * / ^ ! % \ >= Open Source. Freeware. Documented and tested.
PLAY Equations  
An Excel equation graphing tool. Input any equation using up to four variables (P,L,A,Y) then use slider bars to view the effect of changing the variables on the graph.
Submitted: Sep 30, 2005
Excel Projects and Tutorials for Business Calculus  
This site contains Excel workbooks which can be used to supplement a course in business calculus.
Submitted: Dec 06, 1999
Realtime Fourier synthesis  
The following Excel application will allow you to synthesize sounds. Just play with the sliders and enjoy what is happening. Mathematically speaking the sliders control the amplitudes of the overtones of the base frequency.
Submitted: Sep 12, 1999
Random numbers in Excel  
RAND01.XLS is an Excel 5 workbook (17 Kb in a ZIP archive) I've cooked up to illustrate some of the advantages of using arrays while manipulating Worksheets. There is also some interesting use of the Excel Graph object.
Submitted: Sep 02, 1999
xlPrecision 2.0 is an Add-In for Microsoft Excel that provides vastly more precise results from mathematical formulas than Excel provides on its own. xlPrecision also empowers you to use vastly larger (and vastly smaller) numbers than Excel allows on its own, and eliminates the insidious binary conversion errors that plague spreadsheet programs. xlPrecision offers many additional features that take you beyond Excel's capabilities in other ways.
Submitted: Jul 10, 2003
[FREESW]Multi Precision Floating Point Computing for EXCEL  
This Excel addin performs multi-precision floating point arithmetic. Perhaps the first package that extends the standard Excel precision from 15 up to 200 significant digits. It is for Excel 97/98 and consists of a set of functions for arithmetic, trigonometric, logarithm, exponential calculus. Useful for testing algorithms. Help on line. Very easy to use and no installation. .
Submitted: Jul 02, 2001
Mathematical Wheels  
In the paper Wheels on Wheels on Wheels -- Surprising Symmetry in Vol. 69, No. 3 of Mathematics Magazine, June 1996, Frank Farris studies some interesting properties of a spcial form of functions. To study these functions Erich Neuwirth built an Excel model which allows to try out different values for the parameters ni and ai.
Submitted: Sep 12, 1999
Downloadable Excel workbooks using Macros designed for use in UK GCSE and AS/A level teaching plus some other educational material and links.
Submitted: Oct 10, 2006

  Privacy - Trademarks - Feedback - Terms of Use Copyright The MathWorks, Inc.