Any example to do caculus with excel

O

olasa

Here are a few tips:
http://www.tushar-mehta.com/
Search Googles: Calculus Excel
http://www.mang.canterbury.ac.nz/people/jfraffen/sscom/links.htm

Hope it can be of use
Ola Sandström


Enclosed:
http://www.excelforum.com/attachment.php?attachmentid=3641&stc=1

+ From Excel Expert E-Letters:
http://www.j-walk.com/ss/excel/eee/index.htm

POWER FORMULA TECHNIQUE

By Alab Beban

Here is an example of how to solve a set of simultaneous equations
using
Excel.

Start with equations that are linearly independent so that there is,
in fact, a solution; e.g.,

17 = 5x + 3y + 2z
13 = 2x + 4y + z
22 = 3x + 2y + 5z

Put the coefficients of the unknowns in, e.g., A1:C3 (i.e., 5,3,2 in
A1:C1, 2,4,1 in A2:C2, etc.);

Put the constants (17, 13, 22) in, e.g., D1:D3;

Highlight, e.g., E1:E3 and array enter (i.e., enter with
Ctrl+Shift+Enter instead of just Enter)

=MMULT(MINVERSE(A1:C3,D1:D3)

and the solution vector (1,2,3) will appear in E1:E3;
i.e., x=1, y=2, z=3

For a set of equations that does not have a solution, the #VALUE error
will appear in E1:E3.


+-------------------------------------------------------------------+
|Filename: PlotFcn.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3641 |
+-------------------------------------------------------------------+
 
Top