How can I configure EXCEL to do Ancova
 

How can I configure EXCEL to do Ancova
 

Dale

From a post by Pieter Vandenberg.................

While ANOVA is part of the Analysis ToolPak ANCOVA is not.

If you have not yet solved the problem here is a link that show
a simple setup for ANCOVA including an example. To get an idea
of how to set it up just write a worksheet for the example, make
sure you have it working and then modify it to fit your needs.
It should not take long to write the formulas to do such
an analysis.

http://bill.psyc.anderson.edu/exdes/ancova.htm

End Pieter post.................................


Gord Dibben MS Excel MVP


On Tue, 26 Dec 2006 14:17:01 -0800, DaleB
wrote:

How can I configure EXCEL to do Ancova
 

Thank you. This helps.

"Gord Dibben" wrote:

Dale

From a post by Pieter Vandenberg.................

While ANOVA is part of the Analysis ToolPak ANCOVA is not.

If you have not yet solved the problem here is a link that show
a simple setup for ANCOVA including an example. To get an idea
of how to set it up just write a worksheet for the example, make
sure you have it working and then modify it to fit your needs.
It should not take long to write the formulas to do such
an analysis.

http://bill.psyc.anderson.edu/exdes/ancova.htm

End Pieter post.................................


Gord Dibben MS Excel MVP


On Tue, 26 Dec 2006 14:17:01 -0800, DaleB
wrote:

How can I configure EXCEL to do Ancova
 

Thanks for the feedback.

Gord



On Wed, 27 Dec 2006 07:14:00 -0800, DaleB
wrote:

Thank you. This helps.

"Gord Dibben" wrote:

Dale

From a post by Pieter Vandenberg.................

While ANOVA is part of the Analysis ToolPak ANCOVA is not.

If you have not yet solved the problem here is a link that show
a simple setup for ANCOVA including an example. To get an idea
of how to set it up just write a worksheet for the example, make
sure you have it working and then modify it to fit your needs.
It should not take long to write the formulas to do such
an analysis.

http://bill.psyc.anderson.edu/exdes/ancova.htm

End Pieter post.................................


Gord Dibben MS Excel MVP


On Tue, 26 Dec 2006 14:17:01 -0800, DaleB
wrote:




Gord Dibben MS Excel MVP