+ Reply to Thread
Results 1 to 2 of 2

Setting a trendline with a custom slope and intercept

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    AB
    MS-Off Ver
    Excel 2003
    Posts
    1

    Setting a trendline with a custom slope and intercept

    Hello everyone,

    So I have a linear graph and created a trendline using the Excel function. I then used the weighted least squares method to create an equation y = b'x + a' using my x and y values as well as their corresponding uncertainties. Would I be able to set the trendline to a specific slope and intercept? If not, is there another way to do this?

    Thanks

  2. #2
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Re: Setting a trendline with a custom slope and intercept

    Simply generate another column of data to plot along side of your existing data that represents the computed coordinates of the weighted least squares method. Then click on the chart and adjust the plotting field to encompass the new, additional column of data.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

+ 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