+ Reply to Thread
Results 1 to 3 of 3

Equation - Exponential Trendline

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    Bloemfontein
    MS-Off Ver
    2016
    Posts
    5

    Equation - Exponential Trendline

    Good day, I have created a scatter chart with a exponential trendline.
    The equation display as follows (Refer to spreadsheet attached)
    Y=5211.2 e 0.0001x

    How do I write this as a formula in excel?

    For example, for a logarithmic equation the formula in excel will read something like this;
    Y=346938.80In(x) - 7714291.75 (The equation on a logarithmic chart)
    Thus; =346938.80*LN(B35)-7714291.75

    Now I would like to do the same with the exponential equation.
    Chart Equation.jpg
    Last edited by RVNiekerk; 01-23-2019 at 04:13 AM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Equation - Exponential Trendline

    I was pretty sure this question has been answered somewhere: https://www.math.vt.edu/courses/math...pecialFcn.html.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    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: Equation - Exponential Trendline

    One way:

    A
    B
    C
    D
    E
    1
    m
    b
    2
    0.000139
    8.616391
    A2:B2: {=LINEST(LN(B5:B10), A5:A10)}
    3
    4
    Extent
    Value
    Fit
    5
    200
    3,000
    5,677
    C5: =EXP(m * A5 + b)
    6
    500
    5,000
    5,919
    7
    100
    7,000
    5,599
    8
    3,000
    12,000
    8,379
    9
    5,000
    15,000
    11,065
    10
    30,000
    330,000
    357,597
    Entia non sunt multiplicanda sine necessitate

+ 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. Replies: 1
    Last Post: 10-15-2015, 10:08 AM
  2. Double exponential trendline
    By rbulph in forum Excel General
    Replies: 3
    Last Post: 09-16-2012, 10:38 AM
  3. Exponential trendline equation
    By xpat in forum Excel General
    Replies: 1
    Last Post: 07-12-2012, 12:10 AM
  4. [SOLVED] Is Exponential trendline always concave
    By ChemistB in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-31-2012, 01:47 PM
  5. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  6. Exponential trendline offset
    By drjulianof in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-22-2006, 06:10 AM
  7. Exponential trendline offset
    By drjulianof in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-20-2006, 04:55 PM

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