ExcelBanter - analysis of variance with lack of fit in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - analysis of variance with lack of fit in excel (https://www.excelbanter.com/excel-worksheet-functions/160509-analysis-variance-lack-fit-excel.html)

Bob

analysis of variance with lack of fit in excel

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

Mike Middleton

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?

Mike Middleton

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
...
Is it possible to calculate this in excel with a statistical tool?

All times are GMT +1. The time now is 07:29 AM.