View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default p-value, statistics

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