Results 1 to 5 of 5

Reference 'Equation of Trend Line' Values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2008
    Location
    Leamington Spa, UK
    MS-Off Ver
    2010
    Posts
    142

    Question Reference 'Equation of Trend Line' Values

    Hi all,

    I am trying to find out if there is a way to reference the calculated intercept and gradient of a line from a linear trend line created from my data.

    For example my line equation maybe:
    y = 169341x+27.34

    Thus I would like to be able to reference the gradient (169341) and the intercept (27.34) into cells in my spreadsheet. This will allow the ability to modify the graph data and automatically update any formula that I use referring to the intercept and the gradient.

    Any help on the above would be gratefully appreciated as always!

    Cheers,
    Mark
    Last edited by R_S_6; 03-09-2010 at 08:05 AM.

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