Results 1 to 1 of 1

Math Help - Excel Sixth Order Polynomial Problem

  1. #1
    Newbie
    Joined
    May 2012
    From
    Australia
    Posts
    5

    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


    Thanks
    Z.C.

    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; July 27th 2012 at 01: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: April 27th 2011, 03:53 AM
  2. Porblem in a definite integral
    Posted in the Calculus Forum
    Replies: 1
    Last Post: October 22nd 2008, 02:06 PM
  3. Word Porblem (solving inequalitites)
    Posted in the Math Topics Forum
    Replies: 1
    Last Post: January 28th 2008, 08:32 PM
  4. Basic Porblem
    Posted in the Algebra Forum
    Replies: 5
    Last Post: October 26th 2007, 11:13 AM
  5. factoring sixth degrees
    Posted in the Algebra Forum
    Replies: 3
    Last Post: September 26th 2007, 06:45 PM

Search Tags


/mathhelpforum @mathhelpforum