two-way ANOVA

[Andy]

How do I set up and perform a two-way ANOVA test? I am attempting to use the
microsoft office program Excel to do a statistical analysis. However, I have
been unable to figure out, using the 'Help' menu, how to do this

 

[Daniel CHEN]

First you need install the data analysis add-in:
Menu: Tools>Add-Ins, make sure the checkbox for "Data analysis tookpak" is
checked.

Then use data analysis:
Menu: Tools>Data Annalysis> ANOVA

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

 

[Mike Middleton]

Andy -

The ANOVA section of Excel 2003's Offline Help topic "About statistical
analysis tools" shows how to arrange the data on the worksheet.

- Mike
www.mikemiddleton.com