happycow -

I have to do a multiple regression in excel with regression tool(with 4
variables). I successfully got it to work, and a lot of charts and graphs
are out putted. My question has to do with one of the charts. One of the
charts has columns labled "Coefficients", what does this mean? <

The summary output of the Regression tool has a worksheet column
"Coefficients." (There is no chart with such a column.)

I thought it was the slop (b) of the least squares line for each variable.
However some of the values in the coefficients are negative, but if you
look at the output charts the correlation go in a positive direction for
these variables. <

In a multiple regression analysis, the coefficients are "net regression
coefficients" or "partial slopes." Each coefficient measures the average
change in Y for a unit change in an X, assuming the other X values are held
constant (or, after taking into account the other X effects).

The overall pattern of Y vs X may be positive, but after taking the other X
variables into account, the net effect may be negative.

another question i have is on the graphs on noticed that there are two
types output graphic in excel what are the differences? <

One kind of chart shows Y vs X, along with fitted Y. Another shows residuals
(Y minus fitted Y) vs X.

- Mike
www.mikemiddleton.com