+ Reply to Thread
Results 1 to 2 of 2

Waarde van trendlijn krijgen

  1. #1
    Registered User
    Join Date
    Rotterdam, The Netherlands
    MS-Off Ver

    Question Waarde van trendlijn krijgen

    Op het moment heb ik een grafiek met de waterstand van een bepaald gebied. Dit is over een periode van 1 uur. Hierin heb ik een trendlijn geplot. Dit is een polynoom 6. Ik wl graag de waarde van de trendlijn te weten komen zodat ik deze tegenover de waterstand kan zetten. Hierdoor kan ik de golfhoogte bepalen. Echter is het zo dat het mij niet lukt om de waarde van de trendlijn op de punten te weten te komen. Zou iemand mij hiermee kunnen helpen?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Waarde van trendlijn krijgen

    I hope Google translate did its job right.

    Whenever I want to perform a regression on any linear function like a polynomial, I generally prefer to do the regression in the spreadsheet using the LINEST() function. Help file: https://support.office.com/en-us/art...a-fa7abf772b6d pay attention to the remarks section where it says
    Quote Originally Posted by MS Excel help
    you can use LINEST to calculate a range of other regression types by entering functions of the x and y variables as the x and y series for LINEST. For example, the following formula:

    =LINEST(yvalues, xvalues^COLUMN($A:$C))

    works when you have a single column of y-values and a single column of x-values to calculate the cubic (polynomial of order 3) approximation of the form:

    y = m1*x + m2*x^2 + m3*x^3 + b
    With your coefficients calculated in the spreadsheet, it should be a simple matter of entering the appropriate formula (I often prefer the SERIESSUM() function for high order polynomials) into your spreadsheet.

    Does that help?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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