p-value, statistics

W

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.
 
M

Mike Middleton

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. <
Click to expand...

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
 
Top