| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DDE linking with variable from named cell! | Links and Linking in Excel | |||
| Correlation matrix | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
Linear Mode
