Results 1 to 1 of 1

Thread: Excel Sixth Order Polynomial Problem

  1. #1
    May 2012

    Excel Sixth Order Polynomial Problem

    Skip to below if you don't like reading

    Doing an assignment for maths, I applied a sixth order polynomial trend line to a set of data points I measured and the result was the forming of an equation which seemed legitimate, the trend line visually appearing to fit the data points almost exactly with the r^2 value enforcing this (
    0.9997). As apart of this assignment I had to derive the function of the trend line and solve for x when the derived function was equal to zero (find stationary point). I did this and using a numerical analysis method found that this point was at 6.2347. Looking at the graph it was obvious that this was not the case, the stationary point appearing to be approximately where x = 4. I checked over this figure and my working and couldn't find any problem so I decided to graph the equation of the trend line. This produced some surprising results with the trend line following the points till the x=3 and then splitting from the data points rather dramatically (see picture). I don't understand why this occurred... In the attached picture it's clear to see that the trend line for the data points series named "Actual Points" is nothing like that of the second series ("Trendline") however Excel still reports the equations of the two lines as being identical.

    So my question is why is it that the two equations in the picture below are stated by Excel as being the same yet obviously are not ?

    Excel Sixth Order Polynomial Problem-trendline-failure.png


    P.S. It should also be noted that I tried this with all other polynomials below 6th order and all of these worked normally.
    Last edited by Zack171195; Jul 27th 2012 at 12:14 AM. Reason: Spelling
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. [SOLVED] Roots of a Sixth-Degree Polynomial
    Posted in the Calculus Forum
    Replies: 4
    Last Post: Apr 27th 2011, 02:53 AM
  2. Porblem in a definite integral
    Posted in the Calculus Forum
    Replies: 1
    Last Post: Oct 22nd 2008, 01:06 PM
  3. Word Porblem (solving inequalitites)
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: Jan 28th 2008, 07:32 PM
  4. Basic Porblem
    Posted in the Algebra Forum
    Replies: 5
    Last Post: Oct 26th 2007, 10:13 AM
  5. factoring sixth degrees
    Posted in the Algebra Forum
    Replies: 3
    Last Post: Sep 26th 2007, 05:45 PM

Search Tags

/mathhelpforum @mathhelpforum