regression results without using the wizard
 

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

regression results without using the wizard
 

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

"dreamz" wrote in
message ...

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