Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Regression function in 2007, Analysis Tool Pak | Excel Discussion (Misc queries) | |||
The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
regression | Excel Discussion (Misc queries) | |||
Linear Regression using the TREND function | Excel Worksheet Functions |