+ Reply to Thread
Results 1 to 5 of 5

I need to solve a complex power equation

Hybrid View

mrideout I need to solve a complex... 03-16-2015, 12:57 PM
Glenn Kennedy Re: I need to solve a complex... 03-16-2015, 01:52 PM
mrideout Re: I need to solve a complex... 03-17-2015, 12:16 PM
Bernie Deitrick Re: I need to solve a complex... 03-16-2015, 01:59 PM
Glenn Kennedy Re: I need to solve a complex... 03-17-2015, 02:31 PM
  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    France
    MS-Off Ver
    Mac Excel 2011
    Posts
    4

    I need to solve a complex power equation

    Hi,

    I have a standard curve that plots “gain” vs. Fluorescence; it fits a “power” trendline almost perfectly. The equation looks like this

    y = 7E-19x6.7978
    R² = 0.99959

    I have attached a worksheet with the data and curve and you will see that the "x" is raised to the 6.7978th power.

    I would like to use an excel equation to solve quickly for multiple values of x, but I don't understand how to write it. Help would be appreciated!!

    Thanks in advance

    -m
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: I need to solve a complex power equation

    The easiest way to do this is to take natural logs of your data and use LINEST to return slope and intercept and use this for calculation.

    see the attached file...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    10-28-2014
    Location
    France
    MS-Off Ver
    Mac Excel 2011
    Posts
    4

    Re: I need to solve a complex power equation

    Thanks Glenn! Great solution!

    -m

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,272

    Re: I need to solve a complex power equation

    in C2, enter

    =6.96226000111E-19*A2^6.79775404651697

    and copy down.
    Bernie Deitrick
    Excel MVP 2000-2010

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: I need to solve a complex power equation

    You're welcome & thanks for the Rep...

+ 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. Power Trendline Equation used in a cell
    By Ginge1267 in forum Excel General
    Replies: 16
    Last Post: 02-10-2014, 03:48 PM
  2. Help needed while solving a power equation
    By Morgan Flint in forum Excel General
    Replies: 0
    Last Post: 08-14-2008, 06:29 AM
  3. [SOLVED] equation for a power analysis
    By amber riggs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2006, 05:55 AM
  4. [SOLVED] Solve this Equation, Please
    By Barbara Harris in forum Excel General
    Replies: 2
    Last Post: 02-23-2006, 01:45 PM
  5. [SOLVED] How do I could solve a equation
    By Joe Satriani in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2006, 08:45 AM

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