Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel question

  • 11-10-2005 12:10pm
    #1
    Khannie
    Registered Users, Registered Users 2 Posts: 37,485 ✭✭✭✭


    I reckon there's a nice way to do this in excel that would save me hours of effort

    I have a data set

    x1, x2, x2, x4, x5
    y1_1, y1_2, y1_3, y1_4, y1_5
    y2_1, y2_2, y2_3, y2_4, y2_5
    .....
    .....
    .....
    y83_1, etc. etc.

    I can graph x against any of the y sets, then get the graph to work out and display a nice polynomial curve (plus formula....the important part). All of my y values follow some kind of 2nd order polynomial fit.

    What I'd like is to just extract the polynomial formula for each y v's x set.

    The TREND() method allows you to do polynomial fits for single data points or ranges (can't quite figure out how to do this, though I'm sure it would be a useful start), but what I'd like is the formula.

    Anyone?


Comments

  • #2
    Khannie
    Registered Users, Registered Users 2 Posts: 37,485 ✭✭✭✭Khannie


    49 views! And not one among you geeky enough to solve it!

    HANG YOUR HEADS IN SHAME!

    :D


  • #3
    zoro
    Registered Users, Registered Users 2 Posts: 2,243 ✭✭✭zoro


    I actually opened up Excel yesterday to have a look

    "Ah sure it can't be THAT hard"

    I closed it again after a brief excursion with TREND() and swore never to return :)


Advertisement