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.
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 -
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks