+ Reply to Thread
Results 1 to 2 of 2

Two Independent Variable Correlation

  1. #1
    MillerK
    Guest

    Two Independent Variable Correlation

    I want to correlate a single dependent variable(Y) with two idependent
    variables(X1,X2). I am looking to get an equation the gives Y as a fucntion
    of X1 & X2. Has anyone ever done this in excell?

  2. #2
    Jerry W. Lewis
    Guest

    Re: Two Independent Variable Correlation

    Use LINEST() where the range passed for known_x's has two columns.

    Jerry

    MillerK wrote:

    > I want to correlate a single dependent variable(Y) with two idependent
    > variables(X1,X2). I am looking to get an equation the gives Y as a fucntion
    > of X1 & X2. Has anyone ever done this in excell?



+ 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