+ Reply to Thread
Results 1 to 3 of 3

Finding multiple trendlines

  1. #1
    Registered User
    Join Date
    02-26-2008
    MS-Off Ver
    Excel 2016
    Posts
    23

    Finding multiple trendlines

    I have a large dataset of x and y variables. I need to find the trendline (specifically slope (or Beta)) for many groups of data. For example:
    1st I need trendline for -> x1:x100 and y1:y100
    then I need one for x2:x101 and y2:y101
    and so on x3:x102 and y3:y102

    I think the LINEST and LOGEST functions may help but I'm unsure how to use them.

    I hope this makes since, if not, it is basically a rolling regression and I need to find all Betas for each group of 100 observations.

    Thanks in advance,
    Joe

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Beta is just the slope, right?

    With the independent variable in column A, and the dependent variable in column B, in C1 and copy down,

    =LINEST(B1:B100, A1:A100)

  3. #3
    Registered User
    Join Date
    02-26-2008
    MS-Off Ver
    Excel 2016
    Posts
    23
    Yes, the answer was right in my question, that worked for me!
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Finding Multiple matches in same column
    By jerry8989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2008, 02:26 PM
  2. Replies: 1
    Last Post: 04-10-2008, 11:47 AM
  3. Finding Values for Multiple Ranges in one Sheet
    By adnan.rehman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-03-2007, 12:37 AM
  4. Finding top 2 values per group based on multiple criteria
    By schuc in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2007, 10:51 PM
  5. Finding multiple instances of the minimum value
    By mworth01 in forum Excel General
    Replies: 2
    Last Post: 11-10-2006, 05:17 PM

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