two-way ANOVA
 

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

two-way ANOVA
 

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

Then use data analysis:
Menu: ToolsData 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
=================================

"Andy" wrote in message
...
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

two-way ANOVA
 

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

"Andy" wrote in message
...
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