View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xt Xt is offline
external usenet poster
 
Posts: 49
Default Goodness of fit test

On Aug 13, 8:03*am, stats4today
wrote:
I am doing polynomial curve fitting in Excel (2003 and 2007). I have used the
r-squared function, but want the F-value, or F-statistic function. Can
someone help?


p = number of predictors = power in this case
n = number of points
R2 = r-squared value from Excel trendline

F = R2/(1-R2)*(n-p-1)/p

xt