regression results without using the wizard

[dreamz]

i have several independent variables and i want to run a multiple regression on them. for now, i'm only interested in the r-sqared and the p-values. is it possible to calculate the r-squared and p-values for the independent variables with a worksheet function?

thanks.

[Bernard Liengme]

Look in Help, specifically LINEST, SLOPE, INTERCEPT, RSQ,
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dreamz" <[email protected]> wrote in
message news:[email protected]...
>
> i have several independent variables and i want to run a multiple
> regression on them. for now, i'm only interested in the r-sqared and
> the p-values. is it possible to calculate the r-squared and p-values
> for the independent variables with a worksheet function?
>
> thanks.
>
>
> --
> dreamz
> ------------------------------------------------------------------------
> dreamz's Profile:
> http://www.excelforum.com/member.php...o&userid=26462
> View this thread: http://www.excelforum.com/showthread...hreadid=505061
>