View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BG BG is offline
external usenet poster
 
Posts: 31
Default Regression P-Value Function

Thanks for your answer Jerry,

It was a great help. I was looking for the X variable p-value, and just
before you replied to my question I found that it could be obtained using the
FDIST function.

FDIST(x, degrees of freedom 1, degrees of freedom 2)

x is calculated using the degrees of freedom 2 value and, the R squared
(RSQ) value of the x and y data as follows: DOF2-RSQ/(1-RSQ)

DOF2 is the number of Y values minus 2
DOF1 is the number of groups minis 1

I have also just noticed that the X variable p-value is the same as the
Regression Significance F value.

Thanks again for you help