Thread: analysis of variance with lack of fit in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
  
Posts: 762
Default analysis of variance with lack of fit in excel
Bob -

Excel's Analysis ToolPak add-in has three kinds of ANOVA.

If you want the usual summary measures of "lack of fit" for a multiple
regression model, you can use (1) the Regression tool of the Analysis
ToolPak or (2) the array-entered LINEST worksheet function.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Bob" wrote in message
...

analysis of variance with lack of fit in excel

Is it possible to calculate this in excel with a statistical tool?


Reply With QuoteReply With Quote