+ Reply to Thread
Results 1 to 6 of 6

how we can get quadratic equation from one graph(data series)

  1. #1
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Post how we can get quadratic equation from one graph(data series)

    hi every body
    I have a little problem with my data in excel
    and it is :

    I want get a quadratic equation from my data which recieved from one unit in my company like in my sample file in attachment
    please help me
    Attached Files Attached Files
    Last edited by pedjvak; 11-12-2012 at 04:26 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: how we can get quadratic equation from one graph(data series)

    http://office.microsoft.com/en-us/ex...010007461.aspx
    If solved remember to mark Thread as solved

  3. #3
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: how we can get quadratic equation from one graph(data series)

    Dear Patel45

    thanks for your attention but it is not solving my problem
    because it give me a wrong equation
    I try it and unfortunatly it seems have a big telorance when you enter the formula and enter numbers (x) inthe formul it get us wrong result(y)

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: how we can get quadratic equation from one graph(data series)

    My result is y=2x^2+3x-4, it matches perfect

  5. #5
    Forum Contributor
    Join Date
    06-23-2012
    Location
    tehran,iran
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: how we can get quadratic equation from one graph(data series)

    yes it is true
    but when i right click on chart and try which issued on that site(your address)I get this equation
    please advise meCapture.JPG

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: how we can get quadratic equation from one graph(data series)

    That looks like you selected "linear" or "1st order polynomial" when selecting the type of trendline in trendline options. Review your trendline options dialog (review the help file if needed) and make sure you are selecting "polynomial" and "2nd order" for the type of trendline.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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