ExcelBanter - Two Independent Variable Correlation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Two Independent Variable Correlation (https://www.excelbanter.com/excel-discussion-misc-queries/22806-two-independent-variable-correlation.html)

MillerK

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?

Jerry W. Lewis

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?

All times are GMT +1. The time now is 07:27 AM.