How to run a simple "regression" analysis in Excel

[buffalo]

Hi,

I have the following data:

X_1 = A + B * Y_1
X_2 = A + B * Y_2
X_3 = A + B * Y_3

…..
X_200=A+B*Y_200

I have the data for X_1 thru X_200 and Y_1 through Y_200

Now I need to a regression in Excel..so thatI can “optimally” estimate A and B.
How do I do that?

Thanks a lot,
buff

[Asala42]

Easiest way:

Just plot the 2 columns of known x's and y's in a scatterplot, add a trendline. A and B can be pulled from the lines slope and intercept. You can also show the Rsquared value.

Another way:
Go to Tools/Add-ins and add the analysis toolpak. you can then go to tools/data analysis to run a regression.

HTH
Adam

[LTunnicliffe]

You can also use the LINEST function to get the coefficiencts and constant. You can read about it in the help file.

Hope this helps!