+ Reply to Thread
Results 1 to 2 of 2

Convert power trendline equation to formula to fill in missing data

  1. #1
    Registered User
    Join Date
    07-26-2015
    Location
    Leeds, UK
    MS-Off Ver
    2003
    Posts
    1

    Convert power trendline equation to formula to fill in missing data

    Hi everyone,

    I'm presented with the following issue and despite many searches online cannot resolve it at all.

    I've created a scatter graph for various data points and wish to fill in the blanks based on a power trendline curve.

    The curve equation is: y = 5E-39x9.227

    I have no idea as to how to turn this into a usable formula to fill in the blank cells of data.
    Does anyone have any inkling about how to do this please?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Convert power trendline equation to formula to fill in missing data

    It's unclear from the equation what you trying to do.

    maybe this:

    =5*10^-39 * A2^9.227

    If your data start from A2 and below.

+ 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. Help please entering a formula obtained by a polynomial equation trendline
    By Help me, I'm Simon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2015, 02:51 PM
  2. Power Trendline Equation used in a cell
    By Ginge1267 in forum Excel General
    Replies: 16
    Last Post: 02-10-2014, 03:48 PM
  3. [SOLVED] Create trendline equation using formula
    By Debbie Thomson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2013, 05:09 PM
  4. Accessing chart trendline equation with VBA or cell formula
    By BrianJC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-07-2013, 03:26 PM
  5. Power trendline
    By kenppy in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 08:05 AM
  6. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  7. trendline for arrays with missing data points
    By melnik in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2011, 01:25 PM

Tags for this Thread

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