Results 1 to 3 of 3

Math Help - Find this polynomial using this graph.

  1. #1
    Newbie
    Joined
    Aug 2011
    Posts
    7

    Find this polynomial using this graph.

    G'day,
    I have created a graph on excel and have tried to extract the polynomial (I think that is what it is) but excel tells me the wrong polynomial.

    Please open the doc file and extract the polynomial from the graph's data. The first graph is the graph I need the polynomial for. The second is the polynomial that excel gives me which is incorrect.

    The first lot of data is for the graph that I want the polynomial for. The second lot of data is the data from the polynomial that excel gave which is incorrect.

    This is for private purposes and not for schooling of any type.

    I would greatly appreciate your help.
    Attached Files Attached Files
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member Bacterius's Avatar
    Joined
    Nov 2009
    From
    Wellington
    Posts
    927

    Re: Find this polynomial using this graph.

    Extract the polynomial? I think you mean approximate your data using a polynomial. You cannot model your data perfectly using a polynomial, because your data is rough and not smooth while a polynomial is a perfect mathematical curve, so you are just telling excel to try and find a polynomial that fits your data as closely as possible. Here the coefficient of determination for the polynomial 0.0088 x^2 - 0.11x + 16.565 is 0.9707 which means it is a very good (almost perfect, in fact) approximation of your data.

    At least that's what I understand from your question. Feel free to clarify if I missed your point.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Aug 2011
    Posts
    7

    Question Re: Find this polynomial using this graph.

    Quote Originally Posted by Bacterius View Post
    Extract the polynomial? I think you mean approximate your data using a polynomial. You cannot model your data perfectly using a polynomial, because your data is rough and not smooth while a polynomial is a perfect mathematical curve, so you are just telling excel to try and find a polynomial that fits your data as closely as possible. Here the coefficient of determination for the polynomial 0.0088 x^2 - 0.11x + 16.565 is 0.9707 which means it is a very good (almost perfect, in fact) approximation of your data.

    At least that's what I understand from your question. Feel free to clarify if I missed your point.
    Thanks for replying.

    The polynomial that excel gives seems to be the general shape of the data. However, as in graph 2 (the graph of the polynomial excel gives me) the curve goes up around x=13 to x=30 mark, whereas the curve in graph 1 goes up around the x=173 to x=871 mark. So the polynomial 0.0088 x^2 - 0.11x + 16.565 is the general shape of the data in question, but it doesn't actually fit the data.

    Basically, I want to use an equation that fits the trends of the data so that I can equate how much I get taxed, hence the title, 'tax percentage'.

    If you could find an equation for me that calculates the tax percentage that would solve my problem and I would greatly appreciate your help. If you don't understand what I am saying please let me know.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. polynomial graph
    Posted in the Algebra Forum
    Replies: 9
    Last Post: March 18th 2010, 01:37 PM
  2. Graph of a polynomial function
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: May 3rd 2009, 01:18 PM
  3. Graph Polynomial question
    Posted in the Calculus Forum
    Replies: 1
    Last Post: March 8th 2009, 08:54 PM
  4. Sketching graph of polynomial
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: February 19th 2008, 05:33 PM
  5. how to find equation of polynomial from a graph
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: September 16th 2007, 07:04 AM

Search Tags


/mathhelpforum @mathhelpforum