#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel CHEN
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
anova post-hoc analysis: tukey test Ross Excel Worksheet Functions 6 April 22nd 23 09:03 AM
how can I get analysis toolpack for anova calculations rachel1027 Excel Worksheet Functions 3 October 27th 05 07:08 AM
ANOVA Angel Excel Discussion (Misc queries) 1 August 31st 05 08:46 PM
ANOVA procedures and t-test equal variance Noosa Excel Discussion (Misc queries) 1 May 12th 05 06:09 AM


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"