+ Reply to Thread
Results 1 to 5 of 5

apply in equation from fitting curve automatic

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    apply in equation from fitting curve automatic

    can any one help me how can i get this fitting curve equation automatic and apply in it
    Uknow value is In(X)

    Please note that this equation not constant As cell B14 , C14 which get from equation on curve , they can change wih any change in value A2:A8,B2:B8
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: apply in equation from fitting curve automatic

    A
    B
    C
    1
    C
    t
    2
    0
    0
    3
    3
    1
    4
    6
    3
    5
    12.5
    5
    6
    25
    8
    7
    50
    11
    8
    100
    12
    9
    10
    y = m*ln(x) + b
    11
    m
    b
    12
    3.334683
    -2.86617
    A12:B12: {=LINEST(B3:B8, LN(A3:A8))}
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: apply in equation from fitting curve automatic

    please not understand what you mean
    and i would like to know if m and b value will be get automatic or must be enter every time

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: apply in equation from fitting curve automatic

    Select cells A12:B12, paste the formula in the formula bar (without the curly braces), press and hold the Control and shift keys, then press Enter.

  5. #5
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: apply in equation from fitting curve automatic

    Hi

    To find m and b in your formula y=m.ln(x)+b try this formulas
    for m
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    for b
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Don't use in that formulas (A2, B2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Curve fitting questions
    By Joe Miller in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-22-2014, 02:45 AM
  2. Curve Fitting and interpolation
    By salmanisn in forum Excel General
    Replies: 3
    Last Post: 01-24-2011, 04:18 AM
  3. How do you change curve fitting equation formats?
    By PhilHenshaw in forum Excel General
    Replies: 5
    Last Post: 10-06-2009, 01:00 PM
  4. curve fitting
    By [email protected] in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2006, 02:10 PM
  5. curve fitting a charging capacitor type curve
    By mcgradys in forum Excel General
    Replies: 4
    Last Post: 11-15-2005, 08:50 AM
  6. Best fitting curve
    By ladee_bird in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2005, 09:05 AM
  7. [SOLVED] best curve fitting
    By ladee_bird in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-20-2005, 03:05 AM

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