I want to determine the p-value of a regression line. I hope someone can
explain to me how i can do this in excel.


--
wim rademakers
------------------------------------------------------------------------
wim rademakers's Profile: http://www.excelforum.com/member.php...o&userid=30134
View this thread: http://www.excelforum.com/showthread...hreadid=502248

wim rademakers -

I want to determine the p-value of a regression line. I hope someone can
explain to me how i can do this in excel. <

One way is to use the Regression tool, part of the Analysis ToolPak (which
can be installed from your Office/Excel disk).

For simple or multiple regression, it reports two-tailed p-values for the
intercept and for each regression coefficient.

- Mike
www.mikemiddleton.com