PC Review


Reply
Thread Tools Rate Thread

Analysis of 2 groups?

 
 
daman
Guest
Posts: n/a
 
      17th Jan 2008
I am trying to use the Analysis ToolPak add in to crunch some research
numbers. The research is comparing two groups after two different testing
sessions on a 7 point likert scale. Should I use an Anova or Paired T-Test?
Furthermore, any ideas on how to put the data in? I have done both but they
do not look correct. Any thoughts are appreciated.

 
Reply With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      18th Jan 2008
You can do an ANOVA with Tools > Data Analysis > Regression.

Also, check these out:
ANOVA
http://www.isixsigma.com/library/content/c021111a.asp
http://org.elon.edu/econ/sac/anova.htm

Paired t-Test:
http://www.wfu.edu/~massd2/T_test.htm
http://www.stattutorials.com/EXCEL/EXCEL_TTEST2.html


Regards,
Ryan--

--
RyGuy


"daman" wrote:

> I am trying to use the Analysis ToolPak add in to crunch some research
> numbers. The research is comparing two groups after two different testing
> sessions on a 7 point likert scale. Should I use an Anova or Paired T-Test?
> Furthermore, any ideas on how to put the data in? I have done both but they
> do not look correct. Any thoughts are appreciated.
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Q: Automate the Fourier Analysis - Data Analysis Tool pinkpanther Microsoft Excel Discussion 0 14th Jan 2011 04:04 PM
Excel 2002 Analysis ToolPak Regression Analysis Help Requested MH Microsoft Excel Worksheet Functions 1 28th Feb 2009 07:16 AM
Analysis Toolpak-Confidence Level and data analysis questions MH Microsoft Excel Worksheet Functions 0 3rd Jan 2009 06:15 PM
Analysis of 2 groups? daman Microsoft Excel Misc 0 17th Jan 2008 06:55 PM
Analysis ToolPak installed but no Data Analysis option =?Utf-8?B?RXJpYyBTdGVwaGVucw==?= Microsoft Excel Misc 3 2nd Feb 2005 09:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:26 AM.