+ Reply to Thread
Results 1 to 2 of 2

Using the chart equation to calculate formula for a 6th order polynomial

  1. 10-28-2014, 04:50 PM #1
    Daedalus1
    Daedalus1 is offline
    Registered User
    Join Date
    10-28-2014
    Location
    Huddersfield, England
    MS-Off Ver
    2007
    Posts
    1

    Using the chart equation to calculate formula for a 6th order polynomial

    I have a workbook with 2 columns [Temperature] [Stress], hopefully for calculating the maximum stress that a steel can withstand at a particular temperature. I have found that the best trend line is a 6th order polynomial, its not perfect but pretty close. I have displayed the formula for the trend line on the graph but want to use the formula to calculate the Y values [Stress] against the known X value [Temperature]. However I cannot find a way to do this. The formula is y = 9E-13X^6 - 1E-09X^5 + 7E-07X^4 - 0.0002X^3 + 0.0238X^2 - 1.4411X + 191.71.
    I have tried breaking it down such as 9^(-13X^6) but I know I am doing something wrong, it does not want to work.

    Any ideas anyone?

    Thanks

    Daedalus1
    Reply With QuoteRegister To Reply
  2. 10-28-2014, 04:58 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Using the chart equation to calculate formula for a 6th order polynomial

    You could replace "x" by a cell id and write the formula in another cell. Let's say x is in A2

    = 9E(-13)*A2^6 - 1E(-9)*A2^5 + 7E(-07)*A2^4 - 0.0002* A2^3 + 0.0238*A2^2 - 1.4411* A2 + 191.71

    To be more accurate, you should right click on the equation on the graph >"Format Trendline Label"> Number and set the number of digits to at least 5, maybe more.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transferring polynomial chart trendline equation back into spreadsheet error
    By aphurford in forum Excel General
    Replies: 3
    Last Post: 02-23-2012, 12:04 PM
  2. Polynomial regression equation in a formula
    By stumac in forum Excel General
    Replies: 10
    Last Post: 02-14-2012, 09:50 PM
  3. Polynomial equation
    By NuuuFt in forum Excel General
    Replies: 4
    Last Post: 12-18-2011, 11:11 AM
  4. How to display 4 order Polynomial equation from the Excel in VB6 ?
    By sunlite in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-28-2010, 11:21 AM
  5. Replication of polynomial equation in formula
    By RichH6109 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2007, 09:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1