In the workbook that is given to us, in the StableRatesData tab, I changed the sigma to equal 0. How do I go about getting a chart similar to ResidualMatrix(IndexFunction) where I assume my x1 should equal -.25 and my x2 = .15 in the Coefficients column? I think I understand the Tools/Data Analysis/Regression and inputing x1 & y for the data ranges, but how do I get that second independent variable in there to get the resulting sheet1 to look like ResidualMatrix(IndexFunction)? If I try redoing it with the data ranges being for x2 & y, it just shoots out a sheet2 rather than combining the information with sheet1.
Reply: When you input the x range, put in both columns containing x1 and x2. Excel will know to do a 2 variable regression.
[NEAS: The Excel Regression add-in accepts up to 16 independent variables.]
|