Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Regressions with data in (changing) rows
I wish I could attach the Excel file illustraing my question below:
For each date, I have 10 observations of the dependent variable (Y1 to Y10) to be regressed on two explanatory variables (X1 to X10 and Z1 to Z10). The data are entered as follows: Column A is the date (say, 250 days). Columns B to K contain the Y1 to Y10 for each date. Columns M to V contain the Z1 to Z10 for each date. Columns X to AG contain one row of X1 to X10. I know how to get the intercept and slope (using INTERCEPT and SLOPE, or LINEST) if I just regress Y on X or Y on Z only. But I need the intercept and slope coefficients of regressing Y on X and Z for each date. The problem is that the observations X1 to X10 are the same for each date, while Z1 to Z10 are changing over the dates (just like Y1 to Y10). So I am not sure if I need to write a macro for this, or there is a way of "combining" X1 to X10 with Z1 to Z10 for each date, and then I can just use LINEST to regress Y1 to Y10 on X1 to X10 with Z1 to Z10 for each date. Hope I have described the question clearly. Thanks in advance for any help. Best regards, Y. F. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regressions using dates | Excel Worksheet Functions | |||
How do I sort or filter rows without column A data changing? | Excel Discussion (Misc queries) | |||
running regressions in Excel 2003 | Excel Worksheet Functions | |||
Sorting 4 rows of data and changing the text of the highest value. | Excel Discussion (Misc queries) | |||
I used Lotus Help for regressions in MS Excel 99. Now what? | Excel Worksheet Functions |