Results 1 to 2 of 2

Automatically create and update equation that represents the line (polynomial) of data set

Threaded View

Bill123 Automatically create and... 04-10-2013, 12:36 PM
AndyLitch Re: Automatically create and... 04-10-2013, 12:54 PM
  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    1

    Automatically create and update equation that represents the line (polynomial) of data set

    Hi everyone, I'm new here so I hope I'm writing in the right Forum...

    I have a data set, with an X and Y axis, that will be changing quite often. I know I can graph the data set and then display equation, but since the data will be changing often I would like it to be done automatically (I don't need the graph just the equation). The equation that best fits the data is a polynomial one (in all cases).

    I found out that "Linest" function can do this, but when I tried using it it gave me a polynomial equation with 4 parts (ax^3+bx^2+cx+d) and the results didn't match the data nor this equation was like the one displayed by the graph (ax^2+bx+c) even though both were based on the same data.

    An excel document has been attached.

    I would appreciate any kind of help on this!

    Thanks!
    Attached Files Attached Files

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