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
|