Multiple Linear Regression

The way that Excel performs regressions, each call of the regression algorithm can only regress one y=f(x) curve. It sounds like you are trying to get it to regress multiple y=f(x) curves. If you want to do this using the data analysis add-in, you will need to call the add-in 4 times -- once for each of the Y columns.

This might be one of the real advantages to learning to use the LINEST() function with relative and absolute references (http://office.microsoft.com/en-us/ex...010069838.aspx ). Using the LINEST() function (I usually nest it within a TRANSPOSE() function when I have data in columns like this), you can set the known_y's argument as a relative reference, the known_x argument as an absolute reference, then copy the function across to get the parameters for the four equations.