+ Reply to Thread
Results 1 to 3 of 3

Any example to do caculus with excel

  1. #1
    Registered User
    Join Date
    10-05-2004
    Posts
    12

    Any example to do caculus with excel

    Thanks a lot.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    Calculus

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

    Hope it can be of use
    Ola Sandström


    Enclosed: http://www.excelforum.com/attachment...tid=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.
    Attached Files Attached Files

  3. #3
    Jerry W. Lewis
    Guest

    Re: Any example to do caculus with excel

    http://www.stfx.ca/people/bliengme/E...UnderCurve.htm

    Jerry


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1