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.